hi
try this...
=sumproduct((A1:A100="Yes")*(B1:B100="Yes"))

regards
FSt1

"John" wrote:

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?