Hi!

Try this:

=SUMPRODUCT(--(ISNUMBER(SEARCH("CT",A1:A13))))

Biff

"ecohen1" wrote in
message ...

Hi all,
I have a cell "Exams" who contains Exam Description.
For example;

Exam
8086L ANKLE - LEFT
8087FAL FOOT & ANKLE - LEFT
8100 CHEST
8152 ABDOMINAL SERIES
8259 CT SCAN HEAD C-
8100 CHEST
8152 ABDOMINAL SERIES
8100 CHEST
8152 ABDOMINAL SERIES
8100 CHEST
8269 CT SCAN ABDOMEN & PELVIS C-
8100 CHEST
8152 ABDOMINAL SERIES


I would like to count all Exams who contains "CT" in the description.
Please I would like to know if someone can help me.

Thanks


--
ecohen1
------------------------------------------------------------------------
ecohen1's Profile:
http://www.excelforum.com/member.php...o&userid=12988
View this thread: http://www.excelforum.com/showthread...hreadid=488009