Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Old July 15th 09, 12:29 PM posted to microsoft.public.excel.misc
external usenet poster
 
First recorded activity by ExcelBanter: Jul 2009
Posts: 2
Default Auto Sum equivalent for Subtract / Multiply / Divide

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

  #2   Report Post  
Old 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
Default 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   Report Post  
Old July 15th 09, 01:12 PM posted to microsoft.public.excel.misc
external usenet poster
 
First recorded activity by ExcelBanter: Jul 2009
Posts: 2
Default 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   Report Post  
Old July 15th 09, 01:37 PM posted to microsoft.public.excel.misc
external usenet poster
 
First recorded activity by ExcelBanter: Jul 2009
Posts: 1
Default 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
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


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 03: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 09:48 PM


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

Powered by vBulletin® Copyright ©2000 - 2017, Jelsoft Enterprises Ltd.
Copyright 2004-2017 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"

 

Copyright © 2017