If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. 


Thread Tools  Display Modes 
#1




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

Ads 
#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 
Thread Tools  
Display Modes  


Similar Threads  
Thread  Thread Starter  Forum  Replies  Last Post 
add value of 4 cells, multiply by 3 subtract 72 multiply by 80%  George A. Yorks  Excel Discussion (Misc queries)  10  October 25th 06 09:45 PM 
add, multiply then divide  Zetman  Excel Worksheet Functions  3  February 24th 06 02:40 AM 
how do i subtract and divide  crystal  Excel Worksheet Functions  1  October 24th 05 10:01 PM 
subtract and divide  crystal  Excel Worksheet Functions  1  October 24th 05 08:22 PM 
how do I divide or multiply an entire column?  1number  Excel Worksheet Functions  4  March 5th 05 08:48 PM 