Applying Subtotals

[Guest]

Can anyone help?
I am recording a macro that applies a subtotal, I have 2
columns, the first column I want to count at each change
and the other I want to sum at the same place.

 

[Dave Peterson]

Record your macro and do the subtotals based on count (or sum, it won't matter).

After the subtotals are applied (and you're still recording), select the column
that should change and
Edit|Replace
=subtotal(x,
with
=subtotal(y,

Replace x and y with the values you want to change:

3 = CountA (2 = Count, probably not the one)
and
9 = Sum

(I'd include that comma just incase you ever want to distinguish between
"=subtotal(11," and "=subtotal(1,".)