Summing Subtotals
 

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

Summing Subtotals
 

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


"jim" wrote in message
...
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

Summing Subtotals
 

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


"Bernie Deitrick" wrote:

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


"jim" wrote in message
...
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

Summing Subtotals
 

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


"jim" wrote in message
...
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


"Bernie Deitrick" wrote:

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


"jim" wrote in message
...
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

Summing Subtotals
 

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.
--

Regards
Roger Govier

"Bernie Deitrick" <deitbe @ consumer dot org wrote in message
...
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


"jim" wrote in message
...
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


"Bernie Deitrick" wrote:

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


"jim" wrote in message
...
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