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.

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.

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.