Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Another counting question!
I need to be able to count the number of cells in a column containing certain
text words, but only if cells in the same row in 2 other columns contain certain text I have put an example below: A B C High Invalid Death Very Low Invalid MI Low Valid CVA Low Invalid No Complications Low Valid No Complications Very Low Valid MI, Death Very Low Invalid No Complications Low Valid Emergency CABG Very Low Invalid No Complications Very Low Invalid Death Low Invalid Death Very Low Invalid CVA, Death So, I need to count the number of cells in column C that contain either "Death", "CVA", "MI", or "Emergency CABG" or any combination the 4, but only if the cell in the same row in column A = "Low" and the cell in the same row in column B = "Valid". Therefore the answer here would be 2 (3rd and 8th rows). Is this possible? Thanks John |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Counting Question | Excel Discussion (Misc queries) | |||
Counting question | Excel Worksheet Functions | |||
Counting question | Excel Worksheet Functions | |||
Counting Question | Excel Discussion (Misc queries) | |||
Counting question | Excel Discussion (Misc queries) |