| Home |
| Search |
| Today's Posts |
|
#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 |
| 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) | |||
Threaded Mode
