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" wrote in message
...
Can you sum all the numbers in a column that are green only? I
do not want
to sum numbers in other colors.