Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
counting problems
Dear Wizards,
I have a year's worth of data. Each day is on a row. The number of patients in the ICU is in col C. The number of those patients that were 'status 7' are in col D. I want to create another grid that tells me: How many days were there in the year when I had 8 patients AND 4 of them were status 7? then How many days were there in the year when I had 9 patients AND 4 of them were status 7? etc. I'm guessing that each of the cells in my second grid will need to be populated with formulas but I need help with that/those formulas. Thanks for being there! Sam |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
conditional counting with Excel | Excel Worksheet Functions | |||
I'm getting mad - I'm having problems with EXCEL file name length | Excel Discussion (Misc queries) | |||
problems for counting | Excel Worksheet Functions | |||
Counting names in a column but counting duplicate names once | Excel Discussion (Misc queries) | |||
Counting... | Excel Worksheet Functions |