| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
| 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) | |||
| Sum only numbers in red font color | Excel Programming | |||
Linear Mode
