Sum only numbers in red font color

  • Thread starter Thread starter Cathy Floyd
  • Start date Start date
C

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?
 
Cathy,

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

John
 
See response in programming group.

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

OP didn't crosspost. OP multiposted.
 
Sorry, my mistake.

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