Countif Multiple with text

S

sunilkeswani

Hi,

Need help.

How do I count a datasheet for the number of rows which have the number
208 in Column C and "Yes" in Column M?

I can only do a basic COUNTIF, but dont know how to get this

Cheers

Sunny
 
D

Dave

Sunny

You could use sumproduct()

=SUMPRODUCT(--(C2:C50=208),--(M2:M50="Yes"))

I have assumed that your data is in rows 2 to 50, you can adjust as
required.

Let me know if this works for you.

Dave
 
Top