In C2 use =IF(A2="yes","x",(IF(B2="yes","x",""))), then countif the x's at
the bottom of the column.


"John" wrote in message
...
I am trying to make excel count the number of cells that have a certain
criteria. Lets say that I want it to count how many of the cells in a
list
say "Yes". I would enter COUNTIF(A1:A100, "Yes"). What I want to do is
make
the criteria a little more complicated.

I only want it to count the cells in that column that say "yes", but also
the ones in the column next to it that say "Yes" as well.

I only want it To count it once. For example lets say A2 and B2 both say
yes, I only want it to count that as 1.

Is this possible?