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.
|