| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
How do I show a percentage by counting the number of yes answers?
Thank you DaveF for "=COUNTIF(A1:A100,"Yes")"
That worked wonderfully... NOW I need to know how to make it show the percentage - ie - if there are 13 questions and 13 are answered "yes" that would be 100%, if 12 answered yes it would be 90%, 11 = 80%, etc. The number of questions may vary, but if all questions are answered yes, it will always be 100%, if one is answered no, 90%, etc. (Does this make sense? yikes) Thanks! |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How do I show only the whole number w/o eliminating four decimals? | Excel Worksheet Functions | |||
| Show Next Number in sequence | Excel Worksheet Functions | |||
| Function to show percentage of tasks complete | Excel Discussion (Misc queries) | |||
| Percentage of a number | Excel Discussion (Misc queries) | |||
| How can I conditional format to show either a percentage or a whol | Excel Discussion (Misc queries) | |||
Threaded Mode
