Summing Subtotals

  • Thread starter Thread starter jim
  • Start date Start date
J

jim

I have a worksheet with numerous subtotals and a grandtotal. The subtotals
are separated by several individual entries for each subtotal. I have tried
selecting each subtotal and the grand total cell, but when I hit enter it
shows only the last subtotal. What am I doing wrong?
Thanks for your help!
 
Jim,

To sum a column of a sheet with subtotals included, you can use

=SUM(B:B)/2

OR

=SUM(B:B)/3

Since you have the grandtotal showing...

But you really shouldn't need to do that. Describe better what it is that you are looking to do,
and we can come up with a better way - Pivot Tables, perhaps....

HTH,
Bernie
MS Excel MVP
 
Bernie,
Thanks for the response. I have a spreadsheet showing sources of income.
There are 6 subcatergories of income, each with a subtotal. In each subtotal
I have no problem totaling the entries for each category, but when I try to
select each subcategory and enter the result in a grandtotal it only enters
the total for the last subcategory. I am using Excel 2007 in Home & Student.
Hope this helps you.
Thanks again!
jim
 
Jim,

Grandtotals are added automatically.... in all versions, including 2007, if you are you using Data
/ Subtotals...

If you are using the SUBTOTAL worksheet fucntion, you would need to use the SUM()/2 method.

HTH,
Bernie
MS Excel MVP
 
Hi Bernie

If you use =Subtotal(9,A3:A20), then =Subtotal(9,A4:A30)
=Subtotal(9,A31:A50), =Subtotal(9,A51:A80) etc. then use
=SUBTOTAL(9,A3:A80)
will give the Grand Total, as the Subtotal function is intelligent enough to
ignore any existing Subtotals within its range.
 
Back
Top