Averaging only font color black and ignoring font color red

[Ria323]

*NO VBA Please!!*
*Looking to carry down the formula to many cells after it in the average column

The formula below is what I have so far. I need to EXCLUDE the red font from the calculations. With my current formula, it is still including it since it's =*red*, I've tried <>*red but when I pull the formula down to the next row where all numbers in Columns N, T and Y are black, it is still excluding Y in the average.

Help?

Column N	Column T	Column Y	Average
$14.23	$14.80	$17.10

=IF(OR(N7="",N7="*red*"),AVERAGE(Y7,T7),IF(OR(T7="",T7="*red*"),AVERAGE(N7,Y7),IF(OR(Y7="",Y7="*red*"),AVERAGE(N7,T7),AVERAGE(N7,T7,Y7))))

 

[Fluff]

Formulae cannot "see" formats. Are the red numbers actually negative numbers formatted to show in red?

 

[Tom.Jones]

You can't do this with formula.
N7="*red*" cannot be used for font color.
With VBA is possible.

 

[Ria323]

Formulae cannot "see" formats. Are the red numbers actually negative numbers formatted to show in red?

Ohhh ok. No, they are not negative numbers. Thank you!

 

[Ria323]

You can't do this with formula.
N7="*red*" cannot be used for font color.
With VBA is possible.

Gotcha, thank you or your help with this!

 

[Fluff]

How is the font colour changed?