Vba: Application.CountIf with more than one criteria

[Nelson78]

Hello everybody.

I have set up the instruction below that works perfectly (consider Rng is column C of a sheet).

z = Application.CountIf(Rng, "CODE 37")

Now, I have to count if also a second criteria is checked: in particular, on the same row of "CODE 37", the value in column B has to be < 50.

How can I combine the two criteria?

Thank you in advance.

 

[RoryA]

You have to use Countifs just as you would in a formula:

z = Application.CountIfs(Rng, "CODE 37", rng.offset(, -1), "<50")

for example.

 

[Nelson78]

You have to use Countifs just as you would in a formula:

z = Application.CountIfs(Rng, "CODE 37", rng.offset(, -1), "<50")

for example.

Sure, too easy. I could figure it out on my own.
Anyway, thank's.