"Rick Rothstein" wrote in message
...
What about something like this...
=COUNTIF(A1:A99,"0")+COUNTIF(B1:B99,"0")

Rick, does that meet that OP's condition that "[if] A=1 and B=1, count only
once"?


----- original message -----

"Rick Rothstein" wrote in message
...
What about something like this...

=COUNTIF(A1:A99,"0")+COUNTIF(B1:B99,"0")

--
Rick (MVP - Excel)


"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