Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Auto Sum equivalent for Subtract / Multiply / Divide
Is there an Auto Sum equivalent or similar for Subtract / Multiply / Divide???
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
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??? |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
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??? |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
add value of 4 cells, multiply by 3 subtract 72 multiply by 80% | Excel Discussion (Misc queries) | |||
add, multiply then divide | Excel Worksheet Functions | |||
how do i subtract and divide | Excel Worksheet Functions | |||
subtract and divide | Excel Worksheet Functions | |||
how do I divide or multiply an entire column? | Excel Worksheet Functions |