Help needed with Sumproduct

[Wimpie]

Good day

I work with Excel 2010
Can someone please assist with the below
In a sheet called "Daily" I have the below

Date	Day	Hours Driven	Hours Worked	Total Hours	Overtime due
2016/10/01	Saturday	03:53	02:30	06:23	02:23
2016/10/02	Sunday	02:49	07:22	10:12	10:12
2016/10/03	Monday	04:01	03:47	07:49	00:19
2016/10/04	Tuesday	04:38	04:01	08:39	01:19
2016/10/05	Wednesday	01:48	03:22	05:10	-2:19
2016/10/06	Thursday	3:38	05:26	08:50	01:20

<tbody>
</tbody>

In a sheet called "Cycle" I have the below

Cycle Number	Date From	Date To	Overtime Hours	Payment captured	Double Overtime Hours
10	2016/09/19	2016/10/16
11	2016/10/17	2016/11/13

<tbody>
</tbody>

[/SUB]
I need a formula that would add all the Monday's to Saturdays in the Overtime Hours column between the cycle days (it should be 15:26)
And that would calculate the Sundays in the Double Overtime Hours column between the cycle days (it should be 10:12)

After a lot of reading the closest I got was the below
=SUMPRODUCT(--(Daily!$A$2:$A$2000>=Cycle!B12),--(Daily$A$2:$A$2000<=Cycle!C12),--(WEEKDAY(A2:A2000)=2),G2:G2000)
This would however only add the Mondays
I tried to use this formula to calculate the Sundays by replacing the 2 with a 1
but do not get 10:12

 

[Wimpie]

Maybe a Sumifs formula can resolve this

 

[keiserj]

Try this

=SUMIFS(Daily!F2:F7,Daily!A2:A7,">="&cycle!B2,Daily!A2:A7,"<="&cycle!C2)-SUMIFS(Daily!F2:F7,Daily!A2:A7,">="&cycle!B2,Daily!A2:A7,"<="&cycle!C2,Daily!B2:B7,"SUNDAY")

 

[Wimpie]

Keiserj, this is amazing and 100% correct for the Overtime Hours.
Can you please assist me with the formula for the double overtime , this is the same range but should only add Sundays

 

[keiserj]

You should just be able to delete the front half the last formula

=SUMIFS(Daily!F2:F7,Daily!A2:A7,">="&cycle!B2,Daily!A2:A7,"<="&cycle!C2,Daily!B2:B7,"SUNDAY")

 

[Wimpie]

Keiserj, I figured out that by using the last bit of the formula (From the Minus) it gives me exactly the amount of double overtime for Sunday
Again a BIG THANK YOU
You have saved me days and hours of work with this formulas

 

[keiserj]

Your Welcome

Thanks for the Reply!