Home 
Search 
Today's Posts 
#1




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

#2




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




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




Auto Sum equivalent for Subtract / Multiply / Divide
Those are not available Rightclick 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 