unanswered Count with multiple condition with specific date

More
6 months 3 weeks ago #2031 by Khaled2020
Good day to all,
 
I have issue in how to count with condition. I want a summary table  that reading from the data table and give me total number per month with specific criteria as the following:
 
1.      Total Bedridden with PU(Cell V) :
I want to count how many patient with Pressure ulcer site (Cell H), while there is ulcer site that means count as
pressure ulcer), and should patient within the same month for example Jan 2020
which mean Admission Date (Cell E), discharged date Cell L)  or Expired date (Cell M) during Jan 2020.
2.      Total Bedridden without PU(Cell W) :
I want to count how many patient without Pressure ulcer site (Cell H) and should patient within the same month for example Jan
2020 which mean Admission Date (Cell E), discharged date Cell L)  or Expired date (Cell M) during Jan 2020.
 
3.      Long Stay Patient Cell X):
I want to count how many Long Stay patient per month (Cell G) with Number of day more than 30 days (which ready in Cell G)
and patient dose not on the same month for example Total number of Long stay patient on Jan 2020, still admitted during Jan and may discharged date (CellL) or Expired date (Cell M) after Jan 2020.
 
Please see attached Excel sheet.

Attachment not found

Please Log in or Create an account to join the conversation.

Moderators: jaychivoExcelfansqiuhongkun