Count cell

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

ecohen1 - 24 Nov 2005 18:55 GMT

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

Signature

ecohen1

Reply to this Message

Biff - 24 Nov 2005 19:34 GMT

Hi!

Try this:

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

Biff

> Hi all,
> I have a cell "Exams" who contains Exam Description.
[quoted text clipped - 19 lines]
>
> Thanks

Reply to this Message

RAGdyer - 24 Nov 2005 23:01 GMT

Would suggest a small revision to eliminate the possibility of counting
occurances of words containing "ct":
Act
Connect
... etc.

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

Signature

Regards,

RD
----------------------------------------------------------------------------------
Please keep all correspondence within the Group, so all may benefit !
----------------------------------------------------------------------------------

> Hi!
>
[quoted text clipped - 27 lines]
>>
>> Thanks

Reply to this Message

Ashish Mathur - 25 Nov 2005 01:22 GMT

Hi,

You may try the following array formula (Ctrl+Shift+Enter)

=SUM(IF(ISNUMBER(FIND(B10,$B$5:$B$8)),$B$5:$B$8))

B10 will contain CT,
$B$5:$B$8 contains the various exams

Regards

Ashish Mathur

> Hi all,
> I have a cell "Exams" who contains Exam Description.
[quoted text clipped - 19 lines]
>
> Thanks

Reply to this Message