Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.newusers
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.newusers
|
|||
|
|||
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 |
#3
Posted to microsoft.public.excel.newusers
|
|||
|
|||
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 |
#4
Posted to microsoft.public.excel.newusers
|
|||
|
|||
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 |
#5
Posted to microsoft.public.excel.newusers
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Subtotals problem: Excel 2003 (not, AFAIK, the nested subtotals bug) | Excel Discussion (Misc queries) | |||
Summing Subtotals | Excel Worksheet Functions | |||
summing subtotals | Excel Worksheet Functions | |||
Problem with nested subtotals, placing secondary subtotals BELOW . | Excel Discussion (Misc queries) | |||
why are nested subtotals coming out below outer subtotals? | Excel Worksheet Functions |