| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.newusers
|
|||
|
|||
HOW DO YOU TOTAL MORE THAN 30 SUBTOTALS?
PLEASE HELP ME SOLVE THIS PROBLEM!!!
|
|
#2
Posted to microsoft.public.excel.newusers
|
|||
|
|||
|
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!!! |
|
#3
Posted to microsoft.public.excel.newusers
|
|||
|
|||
|
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!!! |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Old Lotus Sub Total & Grand Total formula | Excel Discussion (Misc queries) | |||
| Excel gets subtotals out of order using multiple sorts and subtot. | Excel Discussion (Misc queries) | |||
| pivot table, functions for subtotals | Excel Worksheet Functions | |||
| Total remaining formula | Excel Worksheet Functions | |||
| Subtotal of Subtotal displays Grand Total in wrong row | Excel Worksheet Functions | |||
Linear Mode
