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

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.

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

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

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

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.

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

See http://i25.tinypic.com/ipy6ba.jpg
best wishes
--
Bernard V Liengme
Microsoft Excel MVP
http://people.stfx.ca/bliengme
remove caps from email

"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.