Addition Problem - Red Numbers

[John117]

I have a set of numbers in cells A1:A25. All of them are entered manually. Some of them are in Red Fonts. In cell A26 I would like to get the SUM of RED Numbers ONLY.
How can I do it using formula ????

Thank you
John

 

[Brian from Maui]

I have a set of numbers in cells A1:A25. All of them are entered manually. Some of them are in Red Fonts. In cell A26 I would like to get the SUM of RED Numbers ONLY.
How can I do it using formula ????

Thank you
John

Are the red fonts a result of conditional formatting?

If not, have a look at,

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

 

[John117]

Thank you Brian

That did the trick for me.
Very good info about working with colors in Excel.

Thank you
John