Here's another one...

=SUMPRODUCT(SIGN((A1:A1000)+(B1:B1000)))

This version is slightly more efficient on larger ranges.

--
Biff
Microsoft Excel MVP


"wildbillyd" wrote in message
...
I am attempting to count how many times there is a number greater than zero
in either column A or column B.

My goal is if A=0 and B=0, do not count. If A=0 and B=1, count. If A=1
and
B=1, count only once.

Thank you for any help