How do I count only if either/ or exist
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
|