Auto Sum equivalent for Subtract / Multiply / Divide

  • Thread starter Thread starter ragde
  • Start date Start date
If by 'autosum' you mean the SUM function, then you might wish to know about
PRODUCT
Just as =SUM(A1:A15) performs the operation A1+A2+A3+A4+A5, so
=PRODUCT(A1:A15) finds A1*A2*A3*A4*A5

I suppose subtract might be =-SUM(A1:A5) and divide could be
=1/PRODUCT(A1:A5)

best wishes
 
I mean the SUM result appearing on the Task Bar when a range if numeric cells
are selected.
 
Back
Top