PatsOnFire
New Member
- Joined
- Apr 25, 2016
- Messages
- 3
Hello,
[TABLE="class: grid, width: 500"]
<tbody>[TR]
[TD]WeekDay[/TD]
[TD]Time[/TD]
[TD]Wait Time[/TD]
[TD]End Point[/TD]
[TD][/TD]
[TD]Weekday[/TD]
[TD]From[/TD]
[TD]To[/TD]
[TD]9117 Menu[/TD]
[TD]Commercial - Place an Order[/TD]
[/TR]
[TR]
[TD][TABLE="width: 75"]
<tbody>[TR]
[TD="class: xl65, width: 75"]Mon[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[TD][TABLE="width: 64"]
<tbody>[TR]
[TD="class: xl65, width: 64"]09:13[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[TD]47[/TD]
[TD][TABLE="width: 211"]
<tbody>[TR]
[TD="class: xl65, width: 211"]Commercial - Invoice Inquiries[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[TD][/TD]
[TD][TABLE="width: 64"]
<tbody>[TR]
[TD="class: xl65, width: 64"]Mon[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[TD][TABLE="width: 64"]
<tbody>[TR]
[TD="class: xl65, width: 64"]09:00[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[TD][TABLE="width: 64"]
<tbody>[TR]
[TD="class: xl65, width: 64"]09:15[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[TD]?[/TD]
[TD][/TD]
[/TR]
[TR]
[TD][TABLE="width: 75"]
<tbody>[TR]
[TD="class: xl65, width: 75"]Mon[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[TD][TABLE="width: 64"]
<tbody>[TR]
[TD="class: xl65, width: 64"]09:14[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[TD]16[/TD]
[TD][TABLE="width: 211"]
<tbody>[TR]
[TD="class: xl65, width: 211"]Commercial - Invoice Inquiries[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[TD][/TD]
[TD]Mon[/TD]
[TD]09:15[/TD]
[TD]09:30[/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][TABLE="width: 75"]
<tbody>[TR]
[TD="class: xl65, width: 75"]Mon[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[TD][TABLE="width: 64"]
<tbody>[TR]
[TD="class: xl65, width: 64"]09:14[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[TD]19[/TD]
[TD][TABLE="width: 211"]
<tbody>[TR]
[TD="class: xl65, width: 211"]Commercial - Place an Order[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[TD][/TD]
[TD]Mon[/TD]
[TD]09:30[/TD]
[TD]09:45[/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][TABLE="width: 75"]
<tbody>[TR]
[TD="class: xl65, width: 75"]Mon[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[TD][TABLE="width: 64"]
<tbody>[TR]
[TD="class: xl65, width: 64"]09:16[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[TD]8[/TD]
[TD][TABLE="width: 211"]
<tbody>[TR]
[TD="class: xl65, width: 211"]Commercial - Place an Order[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[TD][/TD]
[TD]Mon[/TD]
[TD]09:45[/TD]
[TD]10:00[/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][TABLE="width: 75"]
<tbody>[TR]
[TD="class: xl65, width: 75"]Mon[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[TD][TABLE="width: 64"]
<tbody>[TR]
[TD="class: xl65, width: 64"]09:16[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[TD]53[/TD]
[TD][TABLE="width: 211"]
<tbody>[TR]
[TD="class: xl65, width: 211"]Commercial - Place an Order[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][TABLE="width: 75"]
<tbody>[TR]
[TD="class: xl65, width: 75"]Mon[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[TD][TABLE="width: 64"]
<tbody>[TR]
[TD="class: xl65, width: 64"]09:22[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[TD]14[/TD]
[TD][TABLE="width: 211"]
<tbody>[TR]
[TD="class: xl65, width: 211"]Commercial - Place an Order[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][TABLE="width: 75"]
<tbody>[TR]
[TD="class: xl65, width: 75"]Mon[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[TD][TABLE="width: 64"]
<tbody>[TR]
[TD="class: xl65, width: 64"]09:24[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[TD]0[/TD]
[TD][TABLE="width: 211"]
<tbody>[TR]
[TD="class: xl65, width: 211"]9117 Menu[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][TABLE="width: 75"]
<tbody>[TR]
[TD="class: xl65, width: 75"]Mon[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[TD][TABLE="width: 64"]
<tbody>[TR]
[TD="class: xl65, width: 64"]09:25[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[TD]16[/TD]
[TD][TABLE="width: 211"]
<tbody>[TR]
[TD="class: xl65, width: 211"]9117 Menu[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][TABLE="width: 75"]
<tbody>[TR]
[TD="class: xl65, width: 75"]Mon[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[TD][TABLE="width: 64"]
<tbody>[TR]
[TD="class: xl65, width: 64"]09:26[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[TD]14[/TD]
[TD][TABLE="width: 211"]
<tbody>[TR]
[TD="class: xl65, width: 211"]Commercial - Place an Order[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][TABLE="width: 75"]
<tbody>[TR]
[TD="class: xl65, width: 75"]Mon[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[TD][TABLE="width: 64"]
<tbody>[TR]
[TD="class: xl65, width: 64"]09:27[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[TD]45[/TD]
[TD][TABLE="width: 211"]
<tbody>[TR]
[TD="class: xl65, width: 211"]9117 Menu[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][TABLE="width: 75"]
<tbody>[TR]
[TD="class: xl65, width: 75"]Mon[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[TD][TABLE="width: 64"]
<tbody>[TR]
[TD="class: xl65, width: 64"]09:32[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[TD]62[/TD]
[TD][TABLE="width: 211"]
<tbody>[TR]
[TD="class: xl65, width: 211"]Commercial - Place an Order[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][TABLE="width: 75"]
<tbody>[TR]
[TD="class: xl65, width: 75"]Mon[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[TD][TABLE="width: 64"]
<tbody>[TR]
[TD="class: xl65, width: 64"]09:34[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[TD]39[/TD]
[TD][TABLE="width: 211"]
<tbody>[TR]
[TD="class: xl65, width: 211"]Commercial - Place an Order[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][TABLE="width: 75"]
<tbody>[TR]
[TD="class: xl65, width: 75"]Mon[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[TD][TABLE="width: 64"]
<tbody>[TR]
[TD="class: xl65, width: 64"]09:36[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[TD]85[/TD]
[TD][TABLE="width: 211"]
<tbody>[TR]
[TD="class: xl65, width: 211"]Commercial - Place an Order[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][TABLE="width: 75"]
<tbody>[TR]
[TD="class: xl65, width: 75"]Mon[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[TD][TABLE="width: 64"]
<tbody>[TR]
[TD="class: xl65, width: 64"]09:38[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[TD]44[/TD]
[TD][TABLE="width: 211"]
<tbody>[TR]
[TD="class: xl65, width: 211"]Commercial - Place an Order[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][TABLE="width: 75"]
<tbody>[TR]
[TD="class: xl65, width: 75"]Mon[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[TD][TABLE="width: 64"]
<tbody>[TR]
[TD="class: xl65, width: 64"]09:38[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[TD]31[/TD]
[TD][TABLE="width: 211"]
<tbody>[TR]
[TD="class: xl65, width: 211"]Commercial - Place an Order[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][TABLE="width: 75"]
<tbody>[TR]
[TD="class: xl65, width: 75"]Mon[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[TD][TABLE="width: 64"]
<tbody>[TR]
[TD="class: xl65, width: 64"]09:39[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[TD]16[/TD]
[TD][TABLE="width: 211"]
<tbody>[TR]
[TD="class: xl65, width: 211"]Commercial - Place an Order[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
</tbody>[/TABLE]
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!
[TABLE="class: grid, width: 500"]
<tbody>[TR]
[TD]WeekDay[/TD]
[TD]Time[/TD]
[TD]Wait Time[/TD]
[TD]End Point[/TD]
[TD][/TD]
[TD]Weekday[/TD]
[TD]From[/TD]
[TD]To[/TD]
[TD]9117 Menu[/TD]
[TD]Commercial - Place an Order[/TD]
[/TR]
[TR]
[TD][TABLE="width: 75"]
<tbody>[TR]
[TD="class: xl65, width: 75"]Mon[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[TD][TABLE="width: 64"]
<tbody>[TR]
[TD="class: xl65, width: 64"]09:13[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[TD]47[/TD]
[TD][TABLE="width: 211"]
<tbody>[TR]
[TD="class: xl65, width: 211"]Commercial - Invoice Inquiries[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[TD][/TD]
[TD][TABLE="width: 64"]
<tbody>[TR]
[TD="class: xl65, width: 64"]Mon[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[TD][TABLE="width: 64"]
<tbody>[TR]
[TD="class: xl65, width: 64"]09:00[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[TD][TABLE="width: 64"]
<tbody>[TR]
[TD="class: xl65, width: 64"]09:15[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[TD]?[/TD]
[TD][/TD]
[/TR]
[TR]
[TD][TABLE="width: 75"]
<tbody>[TR]
[TD="class: xl65, width: 75"]Mon[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[TD][TABLE="width: 64"]
<tbody>[TR]
[TD="class: xl65, width: 64"]09:14[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[TD]16[/TD]
[TD][TABLE="width: 211"]
<tbody>[TR]
[TD="class: xl65, width: 211"]Commercial - Invoice Inquiries[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[TD][/TD]
[TD]Mon[/TD]
[TD]09:15[/TD]
[TD]09:30[/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][TABLE="width: 75"]
<tbody>[TR]
[TD="class: xl65, width: 75"]Mon[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[TD][TABLE="width: 64"]
<tbody>[TR]
[TD="class: xl65, width: 64"]09:14[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[TD]19[/TD]
[TD][TABLE="width: 211"]
<tbody>[TR]
[TD="class: xl65, width: 211"]Commercial - Place an Order[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[TD][/TD]
[TD]Mon[/TD]
[TD]09:30[/TD]
[TD]09:45[/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][TABLE="width: 75"]
<tbody>[TR]
[TD="class: xl65, width: 75"]Mon[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[TD][TABLE="width: 64"]
<tbody>[TR]
[TD="class: xl65, width: 64"]09:16[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[TD]8[/TD]
[TD][TABLE="width: 211"]
<tbody>[TR]
[TD="class: xl65, width: 211"]Commercial - Place an Order[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[TD][/TD]
[TD]Mon[/TD]
[TD]09:45[/TD]
[TD]10:00[/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][TABLE="width: 75"]
<tbody>[TR]
[TD="class: xl65, width: 75"]Mon[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[TD][TABLE="width: 64"]
<tbody>[TR]
[TD="class: xl65, width: 64"]09:16[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[TD]53[/TD]
[TD][TABLE="width: 211"]
<tbody>[TR]
[TD="class: xl65, width: 211"]Commercial - Place an Order[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][TABLE="width: 75"]
<tbody>[TR]
[TD="class: xl65, width: 75"]Mon[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[TD][TABLE="width: 64"]
<tbody>[TR]
[TD="class: xl65, width: 64"]09:22[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[TD]14[/TD]
[TD][TABLE="width: 211"]
<tbody>[TR]
[TD="class: xl65, width: 211"]Commercial - Place an Order[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][TABLE="width: 75"]
<tbody>[TR]
[TD="class: xl65, width: 75"]Mon[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[TD][TABLE="width: 64"]
<tbody>[TR]
[TD="class: xl65, width: 64"]09:24[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[TD]0[/TD]
[TD][TABLE="width: 211"]
<tbody>[TR]
[TD="class: xl65, width: 211"]9117 Menu[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][TABLE="width: 75"]
<tbody>[TR]
[TD="class: xl65, width: 75"]Mon[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[TD][TABLE="width: 64"]
<tbody>[TR]
[TD="class: xl65, width: 64"]09:25[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[TD]16[/TD]
[TD][TABLE="width: 211"]
<tbody>[TR]
[TD="class: xl65, width: 211"]9117 Menu[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][TABLE="width: 75"]
<tbody>[TR]
[TD="class: xl65, width: 75"]Mon[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[TD][TABLE="width: 64"]
<tbody>[TR]
[TD="class: xl65, width: 64"]09:26[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[TD]14[/TD]
[TD][TABLE="width: 211"]
<tbody>[TR]
[TD="class: xl65, width: 211"]Commercial - Place an Order[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][TABLE="width: 75"]
<tbody>[TR]
[TD="class: xl65, width: 75"]Mon[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[TD][TABLE="width: 64"]
<tbody>[TR]
[TD="class: xl65, width: 64"]09:27[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[TD]45[/TD]
[TD][TABLE="width: 211"]
<tbody>[TR]
[TD="class: xl65, width: 211"]9117 Menu[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][TABLE="width: 75"]
<tbody>[TR]
[TD="class: xl65, width: 75"]Mon[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[TD][TABLE="width: 64"]
<tbody>[TR]
[TD="class: xl65, width: 64"]09:32[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[TD]62[/TD]
[TD][TABLE="width: 211"]
<tbody>[TR]
[TD="class: xl65, width: 211"]Commercial - Place an Order[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][TABLE="width: 75"]
<tbody>[TR]
[TD="class: xl65, width: 75"]Mon[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[TD][TABLE="width: 64"]
<tbody>[TR]
[TD="class: xl65, width: 64"]09:34[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[TD]39[/TD]
[TD][TABLE="width: 211"]
<tbody>[TR]
[TD="class: xl65, width: 211"]Commercial - Place an Order[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][TABLE="width: 75"]
<tbody>[TR]
[TD="class: xl65, width: 75"]Mon[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[TD][TABLE="width: 64"]
<tbody>[TR]
[TD="class: xl65, width: 64"]09:36[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[TD]85[/TD]
[TD][TABLE="width: 211"]
<tbody>[TR]
[TD="class: xl65, width: 211"]Commercial - Place an Order[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][TABLE="width: 75"]
<tbody>[TR]
[TD="class: xl65, width: 75"]Mon[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[TD][TABLE="width: 64"]
<tbody>[TR]
[TD="class: xl65, width: 64"]09:38[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[TD]44[/TD]
[TD][TABLE="width: 211"]
<tbody>[TR]
[TD="class: xl65, width: 211"]Commercial - Place an Order[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][TABLE="width: 75"]
<tbody>[TR]
[TD="class: xl65, width: 75"]Mon[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[TD][TABLE="width: 64"]
<tbody>[TR]
[TD="class: xl65, width: 64"]09:38[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[TD]31[/TD]
[TD][TABLE="width: 211"]
<tbody>[TR]
[TD="class: xl65, width: 211"]Commercial - Place an Order[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][TABLE="width: 75"]
<tbody>[TR]
[TD="class: xl65, width: 75"]Mon[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[TD][TABLE="width: 64"]
<tbody>[TR]
[TD="class: xl65, width: 64"]09:39[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[TD]16[/TD]
[TD][TABLE="width: 211"]
<tbody>[TR]
[TD="class: xl65, width: 211"]Commercial - Place an Order[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
</tbody>[/TABLE]
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!