Hello again Roger, Hi Nick
Roger, thanks for your suggestion. I have found a number of sites dealing
with the Summing of cells based on colour. But I want to Sum the contents of
the comments in these coloured cells.

Nick, thanks for your reply particularly dealing with the comments part. I
will digest it and endeavour to implement. Watch this space.

Thanks again Roger


"Roger Govier" wrote:

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?