Subtotals feature

[Guest]

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]

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