| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Formula Question
On an EXCEL sheet - I have a column that in each row it says either YES or
NO - I want a formula that will give me a percentage of on time (yes is on time, no is not) so if 10 rows have answers, and 8 are yes = 80% But, how do I do the formula??? Thanks |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Formula Question
=COUNTIF(A1:A10,"Yes")/COUNTA(A1:A10)
Regards, Peo Sjoblom "Dave" wrote: On an EXCEL sheet - I have a column that in each row it says either YES or NO - I want a formula that will give me a percentage of on time (yes is on time, no is not) so if 10 rows have answers, and 8 are yes = 80% But, how do I do the formula??? Thanks |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Formula Question
=COUNTIF(A:A,"yes")/COUNTA(A:A)*100&"%" Vaya con Dios, Chuck, CABGx3 "Dave" wrote: On an EXCEL sheet - I have a column that in each row it says either YES or NO - I want a formula that will give me a percentage of on time (yes is on time, no is not) so if 10 rows have answers, and 8 are yes = 80% But, how do I do the formula??? Thanks |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Newbie Question - Subtraction Formula Question | Excel Discussion (Misc queries) | |||
| Formula Question | Excel Discussion (Misc queries) | |||
| Excel formula question | Excel Discussion (Misc queries) | |||
| Formula Question | Excel Worksheet Functions | |||
| I have a question regarding countif formula. | Excel Worksheet Functions | |||
Linear Mode
