HOW DO YOU TOTAL MORE THAN 30 SUBTOTALS?
 

PLEASE HELP ME SOLVE THIS PROBLEM!!!

HOW DO YOU TOTAL MORE THAN 30 SUBTOTALS?
 

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?

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

"DREAMPOTTER" wrote in message
...
PLEASE HELP ME SOLVE THIS PROBLEM!!!

HOW DO YOU TOTAL MORE THAN 30 SUBTOTALS?
 

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

On Tue, 12 Sep 2006 14:59:02 -0700, DREAMPOTTER
wrote:

PLEASE HELP ME SOLVE THIS PROBLEM!!!