CountIFS (I think) into results from a range of data

[The_gzb]

Hi, first post, please help

I have a range of data (shown below)

Who	Draft Submission	Final Submission	Due Date	Exception
Dave	31/01/2020​	18/02/2020​	20/02/2020​
Bob	23/04/2020​	04/05/2020​	25/05/2020​
Bob	15/04/2020​	05/05/2020​	12/05/2020​
Mary	06/05/2020​		29/06/2020​
Mary	06/05/2020​		29/06/2020​
Mary		04/05/2020​	12/05/2020​	Y
Dave		05/05/2020​	18/05/2020​	Y
Julie		07/05/2020​	08/06/2020​

I would like to count the number of items within this field based on the information I put in below (between two dates, and if neccessary WHO from above):

Start Date	End Date	Who
01/05/2020	15/05/2020	Bob

Based on that search criteria above I would like my results to look like this below (these are manual entries)

Total Submissions	7​
Final Submissions	5​
Final Submissions in time*	2​
Final Submissions with Draft**	2​
Draft Submissions	2​
Draft Submissions in Time***	2​
Bob Total Submissions	2​
Bob Final Submissions	2​
Bob Final Submissions in time*	2​
Bob Final Submissions with Draft**	2​
Bob Draft Submissions	0​
Bob Draft Submissions in Time***	0​
*Final time requirement is 5 working days before Due Date and excluding Exceptions
**Final submissions with draft excluding Exceptions
***Draft time requirement is 15 workind days before Due Date

So my whole sheet looks like this:

Start Date	End Date	Who					Total Submissions
01/05/2020	15/05/2020	Bob					Final Submissions
							Final Submissions in time*
Who	Draft Submission	Final Submission	Due Date	Exception			Final Submissions with Draft**
Dave	31/01/2020​	18/02/2020​	20/02/2020​				Draft Submissions
Bob	23/04/2020​	04/05/2020​	25/05/2020​				Draft Submissions in Time***
Bob	15/04/2020​	05/05/2020​	12/05/2020​
Mary	06/05/2020​		29/06/2020​				Bob Total Submissions
Mary	06/05/2020​		29/06/2020​				Bob Final Submissions
Mary		04/05/2020​	12/05/2020​	Y			Bob Final Submissions in time*
Dave		05/05/2020​	18/05/2020​	Y			Bob Final Submissions with Draft**
Julie		07/05/2020​	08/06/2020​				Bob Draft Submissions
							Bob Draft Submissions in Time***
							*Final time requirement is 5 working days before Due Date and excluding Exceptions
							**Final submissions with draft excluding Exceptions
							***Draft time requirement is 15 workind days before Due Date

Does that make sense? Please help! And please keep safe during these times