Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Subtotals feature
Excel 2000
I have a table with column headings Agency, Account and Balance. When I use the Subtotal feature "At each change in Agency, sum Balance" and "At each change in Agency, count Account" It places he count and balance sum on different rows. I'd like to have them side by side, but I don't see a way to do it. I've also tried "At each change in Agency, sum Account and Balance" then changed to Sum to Count. However, I always end up with 1 more record than actually exists. Is there a way to force the Subtotal feature to place both the Count and Sum on the same row? |
#2
|
|||
|
|||
Do it just one time, but include both Account and Balance.
Use sum for the function. After you do it, you'll notice that the =subtotal() formula looks like: =subtotal(9,b2:b9) Now you can change the sum to Count for the Balance column. Select that column (C???) edit|replace what: subtotal(9, with: subtotal(3, replace all or maybe: with: subtotal(2, the 9 means sum, 3 means CountA and 2 means Count. (Excel's help will give you all those options.) StephanieH wrote: Excel 2000 I have a table with column headings Agency, Account and Balance. When I use the Subtotal feature "At each change in Agency, sum Balance" and "At each change in Agency, count Account" It places he count and balance sum on different rows. I'd like to have them side by side, but I don't see a way to do it. I've also tried "At each change in Agency, sum Account and Balance" then changed to Sum to Count. However, I always end up with 1 more record than actually exists. Is there a way to force the Subtotal feature to place both the Count and Sum on the same row? -- Dave Peterson |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
The fill feature in Excel that gives option to fill or copy | New Users to Excel | |||
How do I copy an outline w/ subtotals & paste just the subtotals | Excel Discussion (Misc queries) | |||
Excel gets subtotals out of order using multiple sorts and subtot. | Excel Discussion (Misc queries) | |||
Subtotals Problem when Filtering | Excel Discussion (Misc queries) | |||
why are nested subtotals coming out below outer subtotals? | Excel Worksheet Functions |