macro to find percentage

[emilyloz]

Hello I have a column with either the words, Late or On Time listed.

I need to find the percentage of how many entries are Late and how many are on time.

I can't use a simple formula because every time I run a different macro, it clears the contents on the spreadsheet.

the workbook is attached. It is on the "Modify Data" sheet.