Sum cells in different colors

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

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


"heater" <[email protected]> wrote in message
news:[email protected]...
> Can you sum all the numbers in a column that are green only? I
> do not want
> to sum numbers in other colors.