Sum cells in different colors

[heater]

Can you sum all the numbers in a column that are green only? I do not want
to sum numbers in other colors.

 

[Chip Pearson]

You need a VBA macro to do this. See
http://www.cpearson.com/excel/colors.htm ,


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