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.

"Lowkey" wrote in message
...
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.