The Macro Recorder did not record the actions of the
setting I set with the conditional sum tool.

Was wondering if I did something wrong or if Excel doesn't
have the capability to record the actions of conditional
sum.

Tks.

I am interested in this answer too, because it gave me a
hard time too. The way I finally go it to work was to
record a second macro, where I edited the formula with F2
and did the Ctrl+Shift+ Enter.

-----Original Message-----
The Macro Recorder did not record the actions of the
setting I set with the conditional sum tool.

Was wondering if I did something wrong or if Excel
doesn't
have the capability to record the actions of conditional
sum.

Tks.
.

Hi Ryan and David

What do you mean by "conditional sum"? Because the SUMIF function is readily available in VBA, and that really is all you need. Give it a try, the condition(s) you want to sum are actually a lot more flexible in VBA than in the normal worksheet function

SuperJas.