COUNTIF with two conditions

  • Thread starter Thread starter John
  • Start date Start date
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.
 
Back
Top