Counting Textual Answers

L

Lowkey

I want to Count and Total the results of a string of Text cells where Yes=1
and No=0. How do I establish the parameters for Yes and No to equal a numeric
result and then Total the result without creating a Macro? The text answer
needs to be visible: it is the result of a Yes/No choice.
 
A

Andy B

Hi
Alongside the Y/N column use a helper column containing:
=IF(A2="Yes",1,0)
You can then use this column for your total.

Andy.
 
B

Bob Phillips

Do the count and total in one step

=COUNTIF(A:A,"Yes")

=COUNTA(A:A)-COUNTIF(A:A,"Yes")
 
P

Peo Sjoblom

Assumin the Yes and No are in separate cells like if the were in B1:B200 and
you want to count Yes

=COUNTIF(B1:B200,"Yes")

since you only want 1 for Yes you can just count them and the result should
be OK


Regards,

Peo Sjoblom
 
L

Lowkey

Both Andy's and Peo's suggestions work, but I like Peo's better because I
don't have to create a dummy column and hide it.
 
Top