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.
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.