Countif Multiple with text

  • Thread starter Thread starter sunilkeswani
  • Start date Start date
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
 
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
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

countifs Function not giving desired result with date criteria 2
CountIf with And 0
countif 3
Finding the weighted average of text that have been given values 1
using CountIF function or Array? 3
countif 2
COUNTIF with multiple conditions? 7
COUNTIF for 2 columns 6

Back
Top