Formula Question

[Guest]

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

 

[Guest]

=COUNTIF(A1:A10,"Yes")/COUNTA(A1:A10)


Regards,

Peo Sjoblom

 

[Guest]

=COUNTIF(A:A,"yes")/COUNTA(A:A)*100&"%"

Vaya con Dios,
Chuck, CABGx3