LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #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.
 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Counting Cells with specific Colours davethewelder Excel Discussion (Misc queries) 10 March 3rd 08 05:09 PM
Count cells containing specific text dandiehl Excel Discussion (Misc queries) 4 August 21st 07 07:34 PM
count specific text that occurs in a range of cells Tim Excel Discussion (Misc queries) 16 October 10th 06 01:41 AM
count cells that begin with specific text mmer at steelcase Excel Worksheet Functions 7 July 25th 06 09:03 PM
If two cells have specific text to count as 1 Jazzman10 Excel Worksheet Functions 4 June 26th 06 05:09 PM


All times are GMT +1. The time now is 07:07 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"