View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Metolius Dad
 
Posts: n/a
Default 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