column addition question

[D]

I am a column that has the numbers in color, is it possible to add the
numbers together by color, i.e. all red,all blue? If so what would the
formula be.

Thanks

 

[Chip Pearson]

There is no way to do this with a worksheet function. You need a
VBA function. See http://www.cpearson.com/excel/colors.htm .


--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com