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? |
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 |
All times are GMT +1. The time now is 06:44 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com