Data
<colgroup><col span="3"><col></colgroup><tbody>
</tbody>Required end product (Sheet2)
How many vehicles required at any given time?
<colgroup><col><col><col span="10"></colgroup><tbody>
</tbody>
Formula
=SUMIFS(D2:D8,B2:B8,'"<"&Sheet2!B1,C2:C8,">="&Sheet2!C1)
I cant quite get the right results. I hope i am making some sense. Appreciate the help.
START | END | VEHICLES REQUIRED | |
JOB 1 | 1:00 | 2:10 | 2 |
JOB 2 | 1:00 | 2:10 | 3 |
JOB 3 | 0:55 | 2:05 | 2 |
JOB 4 | 0:35 | 1:45 | 2 |
JOB 5 | 0:25 | 1:35 | 2 |
JOB 6 | 0:20 | 1:30 | 2 |
JOB 7 | 0:00 | 1:10 | 1 |
<colgroup><col span="3"><col></colgroup><tbody>
</tbody>
How many vehicles required at any given time?
0:00 | 0:01 | 0:02 | 0:03 | 0:04 | 0:05 | 0:20 | 0:25 | ||||
Vehicles required | 1 | 1 | 1 | 1 | 1 | 1 | 3 | 5 |
<colgroup><col><col><col span="10"></colgroup><tbody>
</tbody>
Formula
=SUMIFS(D2:D8,B2:B8,'"<"&Sheet2!B1,C2:C8,">="&Sheet2!C1)
I cant quite get the right results. I hope i am making some sense. Appreciate the help.