Hello Everyone,
Good Evening. I have the following table.
[TABLE="width: 541"]
<colgroup><col><col span="7"></colgroup><tbody>[TR]
[TD]Shift[/TD]
[TD]Monday[/TD]
[TD]Tuesday[/TD]
[TD]Wednesday[/TD]
[TD]Thursday[/TD]
[TD]Friday[/TD]
[TD]Saturday[/TD]
[TD]Sunday[/TD]
[/TR]
[TR]
[TD]14-May-18[/TD]
[TD]15-May-18[/TD]
[TD]16-May-18[/TD]
[TD]17-May-18[/TD]
[TD]18-May-18[/TD]
[TD]19-May-18[/TD]
[TD]20-May-18[/TD]
[/TR]
[TR]
[TD]23:30 - 9:30[/TD]
[TD]1[/TD]
[TD]1[/TD]
[TD]1[/TD]
[TD]1[/TD]
[TD]1[/TD]
[TD]0[/TD]
[TD]0[/TD]
[/TR]
[TR]
[TD]1:00 - 11:00[/TD]
[TD]2[/TD]
[TD]2[/TD]
[TD]2[/TD]
[TD]3[/TD]
[TD]3[/TD]
[TD]1[/TD]
[TD]1[/TD]
[/TR]
[TR]
[TD]1:30 - 11:30[/TD]
[TD]0[/TD]
[TD]0[/TD]
[TD]0[/TD]
[TD]0[/TD]
[TD]0[/TD]
[TD]0[/TD]
[TD]0[/TD]
[/TR]
[TR]
[TD]2:00 - 12:00[/TD]
[TD]0[/TD]
[TD]0[/TD]
[TD]0[/TD]
[TD]0[/TD]
[TD]0[/TD]
[TD]1[/TD]
[TD]1[/TD]
[/TR]
[TR]
[TD]3:00 - 13:00[/TD]
[TD]6[/TD]
[TD]6[/TD]
[TD]7[/TD]
[TD]6[/TD]
[TD]5[/TD]
[TD]3[/TD]
[TD]2[/TD]
[/TR]
[TR]
[TD]3:30 - 13:30[/TD]
[TD]0[/TD]
[TD]0[/TD]
[TD]0[/TD]
[TD]0[/TD]
[TD]0[/TD]
[TD]0[/TD]
[TD]0[/TD]
[/TR]
[TR]
[TD]4:00 - 14:00[/TD]
[TD]1[/TD]
[TD]2[/TD]
[TD]3[/TD]
[TD]3[/TD]
[TD]3[/TD]
[TD]0[/TD]
[TD]1[/TD]
[/TR]
[TR]
[TD]5:00 - 15:00[/TD]
[TD]6[/TD]
[TD]6[/TD]
[TD]6[/TD]
[TD]4[/TD]
[TD]4[/TD]
[TD]0[/TD]
[TD]0[/TD]
[/TR]
[TR]
[TD]6:00 - 16:00[/TD]
[TD]0[/TD]
[TD]1[/TD]
[TD]1[/TD]
[TD]1[/TD]
[TD]1[/TD]
[TD]0[/TD]
[TD]0[/TD]
[/TR]
[TR]
[TD]7:00 - 17:00[/TD]
[TD]0[/TD]
[TD]0[/TD]
[TD]0[/TD]
[TD]0[/TD]
[TD]0[/TD]
[TD]0[/TD]
[TD]0[/TD]
[/TR]
[TR]
[TD]8:00 - 18:00[/TD]
[TD]7[/TD]
[TD]4[/TD]
[TD]4[/TD]
[TD]5[/TD]
[TD]4[/TD]
[TD]3[/TD]
[TD]4[/TD]
[/TR]
[TR]
[TD]9:00 - 19:00[/TD]
[TD]0[/TD]
[TD]0[/TD]
[TD]0[/TD]
[TD]0[/TD]
[TD]0[/TD]
[TD]0[/TD]
[TD]0[/TD]
[/TR]
[TR]
[TD]14:00 - 00:00[/TD]
[TD]0[/TD]
[TD]0[/TD]
[TD]0[/TD]
[TD]0[/TD]
[TD]0[/TD]
[TD]0[/TD]
[TD]0[/TD]
[/TR]
[TR]
[TD]16:00 - 2:00[/TD]
[TD]3[/TD]
[TD]3[/TD]
[TD]2[/TD]
[TD]2[/TD]
[TD]3[/TD]
[TD]3[/TD]
[TD]3
[/TD]
[/TR]
</tbody>[/TABLE]
The columns are for the total number of people rostered for a shift. What I want is if I select a time slot in it should give me the sum of people rostered.
Example: Slot (2 AM - 3 AM). This slot should have the sum of the first four shifts from the first column corresponding to Monday. So for Monday Slot (2 AM - 3 AM) total rostered should be (1+2+0+0=3).
I hope this is clear. I need a formula to do this. I have tried with IF function but that aint working. PLEASE HELP.
Regards
ROY
Good Evening. I have the following table.
[TABLE="width: 541"]
<colgroup><col><col span="7"></colgroup><tbody>[TR]
[TD]Shift[/TD]
[TD]Monday[/TD]
[TD]Tuesday[/TD]
[TD]Wednesday[/TD]
[TD]Thursday[/TD]
[TD]Friday[/TD]
[TD]Saturday[/TD]
[TD]Sunday[/TD]
[/TR]
[TR]
[TD]14-May-18[/TD]
[TD]15-May-18[/TD]
[TD]16-May-18[/TD]
[TD]17-May-18[/TD]
[TD]18-May-18[/TD]
[TD]19-May-18[/TD]
[TD]20-May-18[/TD]
[/TR]
[TR]
[TD]23:30 - 9:30[/TD]
[TD]1[/TD]
[TD]1[/TD]
[TD]1[/TD]
[TD]1[/TD]
[TD]1[/TD]
[TD]0[/TD]
[TD]0[/TD]
[/TR]
[TR]
[TD]1:00 - 11:00[/TD]
[TD]2[/TD]
[TD]2[/TD]
[TD]2[/TD]
[TD]3[/TD]
[TD]3[/TD]
[TD]1[/TD]
[TD]1[/TD]
[/TR]
[TR]
[TD]1:30 - 11:30[/TD]
[TD]0[/TD]
[TD]0[/TD]
[TD]0[/TD]
[TD]0[/TD]
[TD]0[/TD]
[TD]0[/TD]
[TD]0[/TD]
[/TR]
[TR]
[TD]2:00 - 12:00[/TD]
[TD]0[/TD]
[TD]0[/TD]
[TD]0[/TD]
[TD]0[/TD]
[TD]0[/TD]
[TD]1[/TD]
[TD]1[/TD]
[/TR]
[TR]
[TD]3:00 - 13:00[/TD]
[TD]6[/TD]
[TD]6[/TD]
[TD]7[/TD]
[TD]6[/TD]
[TD]5[/TD]
[TD]3[/TD]
[TD]2[/TD]
[/TR]
[TR]
[TD]3:30 - 13:30[/TD]
[TD]0[/TD]
[TD]0[/TD]
[TD]0[/TD]
[TD]0[/TD]
[TD]0[/TD]
[TD]0[/TD]
[TD]0[/TD]
[/TR]
[TR]
[TD]4:00 - 14:00[/TD]
[TD]1[/TD]
[TD]2[/TD]
[TD]3[/TD]
[TD]3[/TD]
[TD]3[/TD]
[TD]0[/TD]
[TD]1[/TD]
[/TR]
[TR]
[TD]5:00 - 15:00[/TD]
[TD]6[/TD]
[TD]6[/TD]
[TD]6[/TD]
[TD]4[/TD]
[TD]4[/TD]
[TD]0[/TD]
[TD]0[/TD]
[/TR]
[TR]
[TD]6:00 - 16:00[/TD]
[TD]0[/TD]
[TD]1[/TD]
[TD]1[/TD]
[TD]1[/TD]
[TD]1[/TD]
[TD]0[/TD]
[TD]0[/TD]
[/TR]
[TR]
[TD]7:00 - 17:00[/TD]
[TD]0[/TD]
[TD]0[/TD]
[TD]0[/TD]
[TD]0[/TD]
[TD]0[/TD]
[TD]0[/TD]
[TD]0[/TD]
[/TR]
[TR]
[TD]8:00 - 18:00[/TD]
[TD]7[/TD]
[TD]4[/TD]
[TD]4[/TD]
[TD]5[/TD]
[TD]4[/TD]
[TD]3[/TD]
[TD]4[/TD]
[/TR]
[TR]
[TD]9:00 - 19:00[/TD]
[TD]0[/TD]
[TD]0[/TD]
[TD]0[/TD]
[TD]0[/TD]
[TD]0[/TD]
[TD]0[/TD]
[TD]0[/TD]
[/TR]
[TR]
[TD]14:00 - 00:00[/TD]
[TD]0[/TD]
[TD]0[/TD]
[TD]0[/TD]
[TD]0[/TD]
[TD]0[/TD]
[TD]0[/TD]
[TD]0[/TD]
[/TR]
[TR]
[TD]16:00 - 2:00[/TD]
[TD]3[/TD]
[TD]3[/TD]
[TD]2[/TD]
[TD]2[/TD]
[TD]3[/TD]
[TD]3[/TD]
[TD]3
[/TD]
[/TR]
</tbody>[/TABLE]
The columns are for the total number of people rostered for a shift. What I want is if I select a time slot in it should give me the sum of people rostered.
Example: Slot (2 AM - 3 AM). This slot should have the sum of the first four shifts from the first column corresponding to Monday. So for Monday Slot (2 AM - 3 AM) total rostered should be (1+2+0+0=3).
I hope this is clear. I need a formula to do this. I have tried with IF function but that aint working. PLEASE HELP.
Regards
ROY