P
pharmer8
How to I calculate percentage of Yes vs No from a sample of surveys I
collected.
collected.
You are using an out of date browser. It may not display this or other websites correctly.
You should upgrade or use an alternative browser.
You should upgrade or use an alternative browser.
B
Bob I
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.
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.
F
Fred Smith
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.
=6/10
which equals 60%.
So you want a formula something like:
=countif(a1:a10,"yes")/count(a1:a10)
Regards,
Fred.
D
Dave Peterson
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)
=countif(a1:a10,"yes")/counta(a1:a10)
or maybe:
=countif(a1:a10,"yes")/10
(if there could be empty cells)
F
Fred Smith
Yup. Thanks for catching this. Fred.
Dave Peterson said: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)