COUNTIF with two conditions

J

John

I am trying to count values of 9 or greater from column BM only if column U
equals "SHEET2!B6" This is the formula that I thought would work but I
basically need to do a countif with 2 different criterias.


=COUNTIF(SHEET1!U3:U2000, SHEET2!C6, IF(SHEET1!BM3:BM2000>=9))

ex. SHEET1 Row 6 column U = JOHN SHEET2 C6 = JOHN SHEET1 Row 6
column BM = 9

This should bring a result of 1...meaning it counted that row as a positive
response.
 
T

T. Valko

Try it like this:

=SUMPRODUCT(--(Sheet1!U3:U2000=Sheet2!C6),--(Sheet1!BM3:BM2000>=9))
 

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

Top