COUNT CELLS THAT ARE NOT HYPERLINKED OR HAVE A CELL COLOR

Hi

i have a worksheet in Excel where i need to count cells (with names, omitting blanks), that have not been hyperlinked (the hyperlinked cells are colored green) and transfer result to a list. I need it to count how many times a name appears.

Basically it is a list of names and how many times they have not submitted paperwork. 

I have attached a small example to make it easier to understand

I have tried a number of functions, but just cant get it to work, so hoping someone can help

Thanks in advance

Phil