Calculating percentage of non-numeric values.
 

How to I calculate percentage of Yes vs No from a sample of surveys I
collected.

Calculating percentage of non-numeric values.
 

all of them together equals 100 percent.
Yes's divided by Yes's plus No's times 100 is the percent Yes's. Same
way with percent No's, or subtract Yes percent from 100 to get No percent.


pharmer8 wrote:

How to I calculate percentage of Yes vs No from a sample of surveys I
collected.

Calculating percentage of non-numeric values.
 

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.

Calculating percentage of non-numeric values.
 

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

Calculating percentage of non-numeric values.
 

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