dpacinello
New Member
- Joined
- Feb 22, 2024
- Messages
- 1
- Office Version
- 365
- Platform
- Windows
I would like to count the number of admissions or discharges per month. We track the names under either discharges or admissions and dates in a separate column. I want to track admissions for October (just a number is fine), discharges for October admissions for November, discharges for November etc. Is there a way to do this without having to change the whole chart? Right now im just using a =countif(d3:d9, "*October*") but this only gives me total # of all admissions and discharges for each month. I'd like to separate individuals but date and whether they were admitted or dicharged.
EXAPMLY BELOW AS I CANT ADD A SCREENSHOT AT THE MOMENT
admissions discharges. Date.
JOHN. OCTOBER
STACY. OCTOBER
LUCY. OCTOBER
EXAPMLY BELOW AS I CANT ADD A SCREENSHOT AT THE MOMENT
admissions discharges. Date.
JOHN. OCTOBER
STACY. OCTOBER
LUCY. OCTOBER