Count Based on Text and Font colour

Hi All,

I'm not quite sure of the best way to achieve this - I have a column of data with 4 possible text entries (let's say APPLE, PEAR, ORANGE, MANGO) these text entries can be one of two font colours (RED or BLACK).

What I am trying to do is to come up with a simple formula to count how many red and black values there are of each text entry. (ie. how many times is APPLE is font colour red and how many times black, etc).

If something possible with COUNTIFS?

Is it possible to extract the font colour into a helper column? (saying Red or Black as text)

I have a lot of data and sheets to apply do this on, I have a long way of doing it using a VBA

=CountColour(range_data,criteria)

Please Login or Register  to view this content.

but that means I have to sort the text and then enter the range of each text for the formula to search, which takes ages!

Any help appreciated, thank you

Moderator's note: Please take the time to review our rules. There aren't many, and they are all important. Rule #3 requires code tags. I have added them for you this time because you are a new member. --6StringJazzer