Hi,

I would like to be able to count the cell values within a range based on the colour of the text.

e.g.

Based on the data below I would like the function to give me a value of 16 (addition of the 2 red values 7 and 9)

1 (Black)
5 (Black)
7 (Red)
9 (Red)
0 (Black)
9 (Black)