| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Calculating percentage of non-numeric values.
How to I calculate percentage of Yes vs No from a sample of surveys I
collected. |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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. |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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. |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
|
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| getting #DIV/0! when calculating percentage | Excel Worksheet Functions | |||
| Calculating Percentage | Excel Worksheet Functions | |||
| Return Numeric Labels that have different Numeric Values | Excel Worksheet Functions | |||
| Calculating a percentage with the end percentage in mind | Excel Discussion (Misc queries) | |||
| Calculating percentage | Excel Worksheet Functions | |||
Linear Mode
