Hi

Without looking at your attachment (which I won't download) I would suggest
you look he
http://www.cpearson.com/excel/colors.htm

Hope this helps!
Andy.

"davidtips" wrote
in message ...

Hi there!

What formula to use at B18 to count a text or two (ex: how many red &
green?) in a column, based on brand at column A (ex: brand A)?

File attached.

davidiew


+-------------------------------------------------------------------+
|Filename: how to count.JPG |
|Download: http://www.excelforum.com/attachment.php?postid=4067 |
+-------------------------------------------------------------------+

--
davidtips
------------------------------------------------------------------------
davidtips's Profile:
http://www.excelforum.com/member.php...o&userid=19103
View this thread: http://www.excelforum.com/showthread...hreadid=488178