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?

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?

Hi John,
Try:
=SUMPRODUCT(--(((A1:A100="yes")+(B1:B100="yes"))0))
Regards - Dave.

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?