=SUMPRODUCT(--(A1:A100B1:B100))


--


Regards,


Peo Sjoblom



"Railrd" wrote in message
...
Want to count how many times Column A is greater than Column B and looking
for the formula.
ex
A B

4 2
3 6
1 0

Want result of 2