SUMIFS a date is between 2 dates

[JustHooch]

I am having trouble summing a column if a date is between (or equal to) a date range.

The column to total is P
The start date if the range is in column Q
The end date of the range is in column R

	P	Q	R
	Time	Start Date	Stop Date
Row 3	0:20	7/16/2018	7/17/2018
Row 4	0:30	7/16/2018	7/16/2018
Row 5	0:10	7/17/2018	7/20/2018
Row 6	1:15	7/18/2018	7/19/2018
Row 7	0:05	7/19/2018	7/20/2018

<tbody>
</tbody>

The dates to compare are
Dates to compare to is in Cell E4, F5, F6, F7

	E	F	G	H	I
Row 4	7/16/2018	7/17/2018	7/18/2018	7/19/2018	7/20/2018
Row 5	sum	sum	sum	sum	sum

<tbody>
</tbody>

The formula needs to include the start and stop date listed above as well as any date between them.
Example Cell E5 should sum to be 0:20 and Cell H5 should sum to be 1:30

The formula I was working with is "=SUMIFS(P3:P7,Q3:Q7,">="&E4,R3:R7,"<="&E4) but is not working

 

[AhoyNC]

Try changing your formula to:

Excel Workbook
	E	F	G	H	I	J	O	P	Q	R
1
2								Time	Start Date	Stop Date
3								0:20	7/16/2018	7/17/2018
4	7/16/2018	7/17/2018	7/18/2018	7/19/2018	7/20/2018			0:30	7/16/2018	7/16/2018
5	0:50	0:30	1:25	1:30	0:15			0:10	7/17/2018	7/20/2018
6								1:15	7/18/2018	7/19/2018
7								0:05	7/19/2018	7/20/2018
Sheet

 

[JustHooch]

That worked perfectly. Thank you so very much.