Conditional Sum Tool
 

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.

Conditional Sum Tool
 

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

Conditional Sum Tool
 

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.