SUMIFS Between 2 Times and Equals, Using Referenced Cells

[PatsOnFire]

Hello,

WeekDay	Time	Wait Time	End Point		Weekday	From	To	9117 Menu	Commercial - Place an Order
Mon <tbody> </tbody>	09:13 <tbody> </tbody>	47	Commercial - Invoice Inquiries <tbody> </tbody>		Mon <tbody> </tbody>	09:00 <tbody> </tbody>	09:15 <tbody> </tbody>	?
Mon <tbody> </tbody>	09:14 <tbody> </tbody>	16	Commercial - Invoice Inquiries <tbody> </tbody>		Mon	09:15	09:30
Mon <tbody> </tbody>	09:14 <tbody> </tbody>	19	Commercial - Place an Order <tbody> </tbody>		Mon	09:30	09:45
Mon <tbody> </tbody>	09:16 <tbody> </tbody>	8	Commercial - Place an Order <tbody> </tbody>		Mon	09:45	10:00
Mon <tbody> </tbody>	09:16 <tbody> </tbody>	53	Commercial - Place an Order <tbody> </tbody>
Mon <tbody> </tbody>	09:22 <tbody> </tbody>	14	Commercial - Place an Order <tbody> </tbody>
Mon <tbody> </tbody>	09:24 <tbody> </tbody>	0	9117 Menu <tbody> </tbody>
Mon <tbody> </tbody>	09:25 <tbody> </tbody>	16	9117 Menu <tbody> </tbody>
Mon <tbody> </tbody>	09:26 <tbody> </tbody>	14	Commercial - Place an Order <tbody> </tbody>
Mon <tbody> </tbody>	09:27 <tbody> </tbody>	45	9117 Menu <tbody> </tbody>
Mon <tbody> </tbody>	09:32 <tbody> </tbody>	62	Commercial - Place an Order <tbody> </tbody>
Mon <tbody> </tbody>	09:34 <tbody> </tbody>	39	Commercial - Place an Order <tbody> </tbody>
Mon <tbody> </tbody>	09:36 <tbody> </tbody>	85	Commercial - Place an Order <tbody> </tbody>
Mon <tbody> </tbody>	09:38 <tbody> </tbody>	44	Commercial - Place an Order <tbody> </tbody>
Mon <tbody> </tbody>	09:38 <tbody> </tbody>	31	Commercial - Place an Order <tbody> </tbody>
Mon <tbody> </tbody>	09:39 <tbody> </tbody>	16	Commercial - Place an Order <tbody> </tbody>

<tbody>
</tbody>

In cell I2, I would like to Sum array C:C (Wait Time) if the following conditions are met: A:A = F2 (Weekday = Mon), B:B >= G2 (Time >= 09:00), B:B < H2 (Time < 09:15), D:D = I1 (End Point = "9117 Menu"). What would be a possible formula?

Formats:
A:A = General
B:B = General
C:C = General
D:D = General
E:E
F:F = Time
G:G = Time
H:H = Time

Thanks!

 

[Tetra201]

Try

=SUMIFS($C:$C,$A:$A,$F2,$B:$B,">="&$G2,$B:$B,"<"&$H2,$D:$D,I$1)

 

[PatsOnFire]

Try

=SUMIFS($C:$C,$A:$A,$F2,$B:$B,">="&$G2,$B:$B,"<"&$H2,$D:$D,I$1)

Works great thanks!

 

[Tetra201]

You are welcome.