See http://xldynamic.com/source/xld.ColourCounter.html

--
__________________________________
HTH

Bob

"J." wrote in message
...
Hi, I am new to Office '07 and understand that there is a process to count
/
sum cells with specific text colours, without building a macro. I have a
master worksheet which I need to summarise using the count or sum function
for a range of cells which will always be a column or row. However, the
text
in the cells will be one of 6 or 7 of the primary colours. I need the
formulas to count / sum a specific text colour each time. Can anyone help
please? Thanks.