Count designated cells
 

I want to count designated cells (versus a range) only if they meet a certain
criteria:

Count cells A1, C1, E1 and F1 if they contain the word "yes"

A1=No Answer
B1=Yes
C1=Yes
D1=Yes
E1=No Answer
F1=No

In the above example the answer would be 1; cells B1 and D1 are not counted
because they are not designated in the formula, where they would be counted
if a range were used.

Hi!

Try one of these:

=SUM((A1="yes"),(C1="yes"),(E1="yes"),(F1="yes"))

=SUMPRODUCT(--(MOD(COLUMN(A1:F1),2)=1),--(A1:F1="yes"))+(F1="yes")

Biff

"VB" wrote in message
...
I want to count designated cells (versus a range) only if they meet a
certain
criteria:

Count cells A1, C1, E1 and F1 if they contain the word "yes"

A1=No Answer
B1=Yes
C1=Yes
D1=Yes
E1=No Answer
F1=No

In the above example the answer would be 1; cells B1 and D1 are not
counted
because they are not designated in the formula, where they would be
counted
if a range were used.