Home | Contact Us | FAQ | Search & Site Map | Link to Us
Sign In | Join | Other 45 Sites in Network
Home
DiscussionsAccessExcelInfoPathOutlookPowerPointPublisherWord
DirectoryUser Groups
Related Topics
Outlook ExpressInternet ExplorerWindowsMS Server ProductsMore Topics ...

MS Office Forum / Excel / New Users / September 2006

Tip: Looking for answers? Try searching our database.

HOW DO YOU TOTAL MORE THAN 30 SUBTOTALS?

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
DREAMPOTTER - 12 Sep 2006 22:59 GMT
PLEASE HELP ME SOLVE THIS PROBLEM!!!
Andy Wiggins - 12 Sep 2006 23:03 GMT
This might help: http://www.bygsoftware.com/Excel/functions/sum.htm

It shows how to sum 40 numbers.

By the way, did you realise that your Caps Lock key was on?

Signature

Andy Wiggins FCCA
www.BygSoftware.com
Excel, Access and VBA Consultancy
-

> PLEASE HELP ME SOLVE THIS PROBLEM!!!
Gord Dibben - 12 Sep 2006 23:22 GMT
Turn off the Caps Lock and post some detail of what you have now and what you
wish to occur.

If talking about using more than 30 arguments in a formula, there are methods to
overcome that.

One is to use two sets of parens like

=SUM((a1,a2,a3,a9,f5,h7...more than 30 cells))

Show us the formula you are using currently.

Gord Dibben  MS Excel MVP

>PLEASE HELP ME SOLVE THIS PROBLEM!!!

Rate this thread:






 
Sign In
Join
My Latest Posts
My Monitored Threads
My Blog
My Photo Gallery
My Profile
My Homepage

Start New Thread
Enable EMail Alerts
Rate this Thread



©2008 Advenet LLC   Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.