I have a spreadsheet with numbers from 1-20 in column A and a formula that

returns either a yes or 0(blank) in column D. I am trying to set a formula

that would look down A and if it contains a 1 give me the total number of

ones and then the total number of ones with "yes" only then give me the

percentage of 1's with no "yes" Because Yes means you were late and I need to

know the percentage of on time. I need to do this with the 2's in column A

and the 3's in column A and so on until I get to 6's then it will be 6 and

up...

Any help or advice would be greatly appreciated.

## Bookmarks