julesrapley
New Member
- Joined
- Oct 16, 2020
- Messages
- 3
- Office Version
- 365
- Platform
- Windows
Hi all - not a coder - not an anything other than someone trying to make my life a little easier at work. Here's my problem (basing this on just one person and one row, I can size up later)
1st sheet (Db) has name of person, start date of course (F2) then column for if they completed (yes, no, in progress, waiting) (H2)
3rd sheet (Data) has the 2020/21 quarter dates eg. B7 is 01/04/2020 and B8 is 30/06/2020, Brit date format)
2nd sheet has the stats I need to input = Total courses Q1, etc.
So .... =COUNTIFS(Db!F2,">="&Data!B7,Db!F2,"<="&Data!B8,Db!H2,"<>no") will tell me if the one person has had a single course between specific dates with only No as being not counted
My problem is the same person can start multiple courses within the same quarter (start dates at cells L2, R2, X2 and AD2 with completion question at cells N2, T2, Z2 and AF2)
What is the formula for giving the total number of courses completed by that person within that quarter?
Hope that made sense!
1st sheet (Db) has name of person, start date of course (F2) then column for if they completed (yes, no, in progress, waiting) (H2)
3rd sheet (Data) has the 2020/21 quarter dates eg. B7 is 01/04/2020 and B8 is 30/06/2020, Brit date format)
2nd sheet has the stats I need to input = Total courses Q1, etc.
So .... =COUNTIFS(Db!F2,">="&Data!B7,Db!F2,"<="&Data!B8,Db!H2,"<>no") will tell me if the one person has had a single course between specific dates with only No as being not counted
My problem is the same person can start multiple courses within the same quarter (start dates at cells L2, R2, X2 and AD2 with completion question at cells N2, T2, Z2 and AF2)
What is the formula for giving the total number of courses completed by that person within that quarter?
Hope that made sense!