Yup. Thanks for catching this. Fred.

"Dave Peterson" wrote in message
...
I bet you wanted =counta() in the denominator:

=countif(a1:a10,"yes")/counta(a1:a10)

or maybe:
=countif(a1:a10,"yes")/10

(if there could be empty cells)

Fred Smith wrote:

If you have 10 responses and 6 are Yes, what's the Yes percentage? It's:
=6/10
which equals 60%.

So you want a formula something like:
=countif(a1:a10,"yes")/count(a1:a10)

Regards,
Fred.

"pharmer8" wrote in message
...
How to I calculate percentage of Yes vs No from a sample of surveys I
collected.

--

Dave Peterson