ExcelBanter - Formula Question

ExcelBanter (https://www.excelbanter.com/)

- Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)

- - Formula Question (https://www.excelbanter.com/excel-discussion-misc-queries/89876-formula-question.html)

Dave

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

Peo Sjoblom

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

CLR

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

All times are GMT +1. The time now is 10:13 AM.