Auto Sum equivalent for Subtract / Multiply / Divide
 

Is there an Auto Sum equivalent or similar for Subtract / Multiply / Divide???

Auto Sum equivalent for Subtract / Multiply / Divide
 

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
--
Bernard V Liengme
Microsoft Excel MVP
http://people.stfx.ca/bliengme
remove caps from email


"ragde" wrote in message
...
Is there an Auto Sum equivalent or similar for Subtract / Multiply /
Divide???

Auto Sum equivalent for Subtract / Multiply / Divide
 

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

"Bernard Liengme" wrote:

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
--
Bernard V Liengme
Microsoft Excel MVP
http://people.stfx.ca/bliengme
remove caps from email


"ragde" wrote in message
...
Is there an Auto Sum equivalent or similar for Subtract / Multiply /
Divide???

Auto Sum equivalent for Subtract / Multiply / Divide
 

Those are not available

Right-click on the status bar to see what functions are available.


--
NBVC

Where there is a will there are many ways.
'The Code Cage' (http;//www.thecodecage.com)
------------------------------------------------------------------------
NBVC's Profile: http://www.thecodecage.com/forumz/member.php?userid=74
View this thread: http://www.thecodecage.com/forumz/sh...d.php?t=116139