ExcelBanter - Countif Multiple with text

ExcelBanter (https://www.excelbanter.com/)

- Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)

- - Countif Multiple with text (https://www.excelbanter.com/excel-worksheet-functions/96346-countif-multiple-text.html)

[email protected]

Countif Multiple with text

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

Dave

Countif Multiple with text

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
wrote in message
oups.com...
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

[email protected]

Countif Multiple with text

Dave,

This works just fine, thank you very much !

Cheers
Sunny

Dave

Countif Multiple with text

Glad to help

Dave

wrote in message
ups.com...
Dave,

This works just fine, thank you very much !

Cheers
Sunny

All times are GMT +1. The time now is 11:26 PM.