| 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? |
| Reply |
| 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 | |||
![Bob Phillips[_5_] is offline](https://www.excelbanter.com/images/SultanThemeVB3R/statusicon/user_offline.gif)
Linear Mode
