| Home |
| Search |
| Today's Posts |
|
|
|
#1
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 | |||
![Fred Smith[_4_] is offline](https://www.excelbanter.com/images/SultanThemeVB3R/statusicon/user_offline.gif)
Hybrid Mode
