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

"Lowkey" wrote:

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.