VBA ~ Need help with counting each code based on font color with no strikethroughs.

I am creating a report that analyzes pre and post occurances and need to count items based on a 4 character code, that matches a font color but has no strikethroughs. I have a matrix that I reference for the 4 character code, it's description, and last the count...for which I need the formula. The data I need to count is in another worksheet within the workbook.
Below is an example of the matrix and data.