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 |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
counting problems
Assuming your data is in C1:D100 (adjust as necessary, but Sumproduct cannot
use an entire column of 65536 rows) =SUMPRODUCT(--(C1:C100=8), --(D1:D100=4)) But instead of hardcoding the criteria (8 and 4), you could use a reference to cells that contain the criteria. "Metolius Dad" wrote: 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 |
Reply |
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 |