How to put COUNTIFS formula in Macro

[Manish_Gupta]

Hello Guys,

I need a help in putting a CountIFS formula into Macro.

There are 2 sheets (“Data” and “Summary”) in the attached file. I am using a CountIFS formula in Column C of “Summary” sheet which check the dealer name present in Column A of same sheet and then count the no. of entries of same dealer name present in Column E of “Data” sheet with value as "Escalated to level 2" in column D.

I want to insert this CountIFS formula into Macro which count the no. of used rows in column A and automatically insert the formula in column C against used rows of column A in "Summary" sheet.

Or if this can be do directly through a Macro that will also solve my problem.

Thanks,
MG

[Richard Buttrey]

Hi,

This is one way

Please Login or Register  to view this content.

But have you considered a Pivot Table which is arguably preferable and certainly more flexible. See attached.