Remember Me?

#1
July 15th 09, 12:29 PM posted to microsoft.public.excel.misc
 external usenet poster First recorded activity by ExcelBanter: Jul 2009 Posts: 2
Auto Sum equivalent for Subtract / Multiply / Divide

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

#2
July 15th 09, 12:41 PM posted to microsoft.public.excel.misc
 external usenet poster First recorded activity by ExcelBanter: Feb 2009 Posts: 1,104
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
July 15th 09, 01:12 PM posted to microsoft.public.excel.misc
 external usenet poster First recorded activity by ExcelBanter: Jul 2009 Posts: 2
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
July 15th 09, 01:37 PM posted to microsoft.public.excel.misc
 external usenet poster First recorded activity by ExcelBanter: Jul 2009 Posts: 1
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

 Posting Rules Smilies are On [IMG] code is On HTML code is OffTrackbacks are On Pingbacks are On Refbacks are On

 Similar Threads Thread Thread Starter Forum Replies Last Post George A. Yorks Excel Discussion (Misc queries) 10 October 25th 06 09:45 PM Zetman Excel Worksheet Functions 3 February 24th 06 03:40 AM crystal Excel Worksheet Functions 1 October 24th 05 10:01 PM crystal Excel Worksheet Functions 1 October 24th 05 08:22 PM 1number Excel Worksheet Functions 4 March 5th 05 09:48 PM

All times are GMT +1. The time now is 06:49 AM.