View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
J. J. is offline
external usenet poster
 
Posts: 6
Default 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.