Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Sum only numbers in red font color
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? |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
SUM numbers of a certain font color | Excel Discussion (Misc queries) | |||
Font color for negative numbers | New Users to Excel | |||
Font color for negative numbers | New Users to Excel | |||
Can I total only numbers with a specific font color? | Excel Discussion (Misc queries) | |||
calculate numbers based on font color? | Excel Worksheet Functions |