Problem:
Counting the number of even numbers in column A, matching even numbers in column B.
Solution:
Using the SUMPRODUCT and MOD functions, as follows:
=SUMPRODUCT((MOD(A2:A7,2)=0)*(MOD(B2:B7,2)=0))
Example:
List1_____List2
2_________6
5_________10
30________8
40________11
33________20
1_________7
Result 2
Bookmarks