ExcelBanter - Sum only numbers in red font color

ExcelBanter (https://www.excelbanter.com/)

- Excel Programming (https://www.excelbanter.com/excel-programming/)

- - Sum only numbers in red font color (https://www.excelbanter.com/excel-programming/273343-re-sum-only-numbers-red-font-color.html)

John Wilson

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?

All times are GMT +1. The time now is 01:33 AM.