COUNTIF with two conditions

[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. Valko]

Try it like this:

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

 

[Max]

To get this evaluation

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

untested, but I think you could try this:
=SUMPRODUCT((SHEET1!U3:U2000=SHEET2!C6)*(SHEET1!BM3:BM2000>=9))
--
Max
Singapore
http://savefile.com/projects/236895
Downloads:22,500 Files:370 Subscribers:66
xdemechanik
---