I need to count and / or sum cells with specific text colours. Hel

[J.]

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.

 

[Jarek Kujawa]

http://www.cpearson.com/Excel/colors.aspx

 

[Bob Phillips]

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

 

[Bernard Liengme]

See http://i25.tinypic.com/ipy6ba.jpg
best wishes