Thread: Sum only numbers in red font color
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
John Wilson John Wilson is offline
external usenet poster
  
Posts: 550
Default Sum only numbers in red font color
Cathy,

Take a look he

http://www.cpearson.com/excel/colors.htm

John

Cathy Floyd wrote:

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?

Reply With QuoteReply With Quote