Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Subtotals
I have 200 subtotals in a spread sheet, with varied no. of rows in each
group, how do I sum up the subtotal rows only to get Grand total. Normal SUM function is only max 30 numbers, fomula is too long in this case. |
#2
|
|||
|
|||
Maybe you can cheat a little.
If every row of data is included in one subtotal then you can SUM the entire range and divide that by 2 (You have added each number twice) =SUM(A1:A100)/2 "Ram" wrote in message ... I have 200 subtotals in a spread sheet, with varied no. of rows in each group, how do I sum up the subtotal rows only to get Grand total. Normal SUM function is only max 30 numbers, fomula is too long in this case. |
#3
|
|||
|
|||
if you are using the SUBTOTAL Worksheet Function
it does not include subtotals. The main thing that SUBTOTAL(9, range) is used for is for filtered lists. --- HTH, David McRitchie, Microsoft MVP - Excel [site changed Nov. 2001] My Excel Pages: http://www.mvps.org/dmcritchie/excel/excel.htm Search Page: http://www.mvps.org/dmcritchie/excel/search.htm "Paul Corrado" wrote in message ... Maybe you can cheat a little. If every row of data is included in one subtotal then you can SUM the entire range and divide that by 2 (You have added each number twice) =SUM(A1:A100)/2 "Ram" wrote in message ... I have 200 subtotals in a spread sheet, with varied no. of rows in each group, how do I sum up the subtotal rows only to get Grand total. Normal SUM function is only max 30 numbers, fomula is too long in this case. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Copying Subtotals? | Excel Discussion (Misc queries) | |||
In Excel, how do you copy and paste just the subtotals into anoth. | Excel Discussion (Misc queries) | |||
Pivot table subtotals 100% | Excel Discussion (Misc queries) | |||
Pivot table subtotals 100% | Excel Discussion (Misc queries) | |||
Sorting a list with subtotals | Excel Worksheet Functions |