Conditional Sum Tool

  • Thread starter Thread starter Ryan
  • Start date Start date
R

Ryan

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