Avatar of gregsutton
gregsutton

asked on 

Count cell values based on text colour

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)
VB ScriptMicrosoft Excel

Avatar of undefined
Last Comment
gregsutton

8/22/2022 - Mon