Cathy,

Here's one way, from a previous reply of mine

http://tinyurl.com/irof


--

HTH

Bob Phillips

"Cathy Floyd" wrote in message
...
I am looking for a formula to sum only the numbers that
appear in red font color. I tried using this formula: =IF
((font.color=_RGB(255,0,0)),SUM(K5:K25060),0), but it did
not work. Any suggestions?