Hello

I am trying to write a function that will count by multiple criteria and font colour.
I basically want to be able to determine the number of human errors per person whilst omitting names in red.
I have a column of names (those with failing result) and a column of causes.
I realise I can use the countifs function for the names and human error but I can't omit those in red.
I can write a function that will count how many times a name appears in a range, omitting the red ones. How can I merge these?
I have also written a function that will count human errors in a given range. I just can't seem to make it count how many human errors per person for a given range!
Out of interest I'd like to work out the VBA code for this, as well as actually finding a solution.