No, it doesn't... I skimmed the OP's question too fast and completely missed
that requirement. Thanks for pointing it out.

--
Rick (MVP - Excel)


"Joe User" <joeu2004 wrote in message
...
"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