COUNTIF and COUNTA formula as a percentage

[Springer_30]

Good day

Have not posted here in ages but have a small problem

In the sheet below there are for example five students who have arrived either "Late" or "On Time" for classes over a period of three days

How do I calculate the percentage for each student of being "On Time" for the three days using COUNTIF and /or COUNTA?

Day 1	On Time / Late		Name	% On Time
David	Late		David
John	On Time		John
Simon	On Time		Simon
Mary	On Time		Mary
Kate	On Time		Kate
Day 2
David	Late
John	On Time
Simon	On Time
Mary	Late
Kate	On Time
Day 3
David	Late
John	Late
Simon	On Time
Mary	On Time
Kate	Late

<tbody>
</tbody>

 

[steve the fish]

Firstly that isnt a great way to set out your data. You would be much better off having the headers Name, Day and On Time/Late rather than just the two headers and blocks of days. That said you can use COUNTIFS. eg:

=COUNTIFS(A:A,D2,B:B,"On Time")/COUNTIFS(A:A,D2)

Format to percentage.

 

[Springer_30]

Thanks Steve, it has worked

BTW, I do fully agree that the way the data was set out isn't great at all, it was however just put together for the purpose of attaining the formula