HOW DO YOU TOTAL MORE THAN 30 SUBTOTALS?

G

Gord Dibben

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

How to create a bubble chart with more than 2 variables. 0
Combine Sumifs with Subtotal 0
Incone & Expenses Statement 0
Macro Pause to Select range then Subtotal 0
How do I add a break after each subtotal? 1
How can the font and size of (all) citation numbers be altered? 1
Resctricting editing rights, but allowing those who cant edit, to still copy the slides 0
Weigh tasks 0

Top