CountIF

[John]

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?

 

[FSt1]

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

regards
FSt1

 

[Dave]

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

 

[mjmeyer]

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