Comparing corresponding cells in different ranges in Excel

99 views Asked by At

I want to be able to compare each cell in a range say B1:B10 with the corresponding cell in another range, say C1:C10 and count the cells that match a criteria like if B1 >= C1, and if B2 >= C2, and if B3 >= C3 and so on.

1

There are 1 answers

3
Gary's Student On BEST ANSWER

Consider:

=SUMPRODUCT(--((B1:B10)>=(C1:C10)))

EDIT#1:

This version will exclude text cells:

=SUMPRODUCT(--((B1:B10)>=(C1:C10))*ISNUMBER(B1:B10)*ISNUMBER(C1:C10))