Hi
only possible with VBA. See
http://www.xldynamic.com/source/xld.ColourCounter.html
and
http://www.cpearson.com/excel/colors.htm


--
Regards
Frank Kabel
Frankfurt, Germany
"Steve Wood" schrieb im Newsbeitrag
...
Is there a method that I can sum all cells of a certain cell colour? Eg.
sum
of all cells colured red? TIA