Count designated cells

[Guest]

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.

 

[Biff]

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