On Aug 25, 8:24 pm, Craig wrote:
I need to count the number of times that 10 occurs at the same time in two
columns:
A B
1 3 4
2 10 6
3 10 10
4 5 10
5 10 10
In this example it happens twice so I would want my SUM(IF...) formula to
total 2.

=SUMPRODUCT(--($A$1:$A$5=10),--($B$1:$B$5=10))

Ken Johnson