Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Count cell
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 |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Count cell
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 |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Count cell
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)))) -- Regards, RD ---------------------------------------------------------------------------------- Please keep all correspondence within the Group, so all may benefit ! ---------------------------------------------------------------------------------- "Biff" wrote in message ... 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 |
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Count cell
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 "ecohen1" wrote: 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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
copying cell names | Excel Discussion (Misc queries) | |||
Cell color based upon cell value | Excel Discussion (Misc queries) | |||
cell color index comparison | New Users to Excel | |||
Can I create a cell that will count by one every time I print the. | Excel Worksheet Functions | |||
Show Blank is cell value=0 but count as a zero in sum. How to format this cell ? | Excel Discussion (Misc queries) |