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.