Sum only numbers in red font color

[Cathy Floyd]

I am trying to creat a formula that sums only the numbers
that appear in red font color. I can not get my formula to
work. Here is what I tried: =IF((font.color=_RGB
(255,0,0)),SUM(K5:K25060),0)

Any suggestions?

 

[John Wilson]

Cathy,

Please don't post to more than one group with the same question.
See .programming for an answer

John

 

[Harlan Grove]

See response in programming group.

Cross=posting is not good, if you want to post to many groups, please do so
in one message,

OP didn't crosspost. OP multiposted.

 

[Bob Phillips]

Sorry, my mistake.

Shouldn't have made that one, especially as I agree with your position on
this (I really do!).