Hi Arran

Take a look at Bob Phillips site
http://xldynamic.com/source/xld.ColourCounter.html

--
Regards

Roger Govier


"Arran" wrote in message
...
I have looked at C Pearsons and others stuff on Sumproduct background
fill
colour But what I would like to do is Sum numbers contained in
comments, from
cells with a certain background colour. Can it be done, if so how?