TABLE 1
[TABLE="width: 647"]
<colgroup><col><col><col><col><col><col><col><col></colgroup><tbody>[TR]
[TD]NAME[/TD]
[TD]SUNDAY[/TD]
[TD]MONDAY[/TD]
[TD]TUESDAY[/TD]
[TD]WEDNESDAY[/TD]
[TD]THURSDAY[/TD]
[TD]FRIDAY[/TD]
[TD]SATURDAY[/TD]
[/TR]
[TR]
[TD]A ASBURY[/TD]
[TD]1[/TD]
[TD]1[/TD]
[TD]1[/TD]
[TD]1[/TD]
[TD]1[/TD]
[TD] [/TD]
[TD] [/TD]
[/TR]
[TR]
[TD]N PATEL[/TD]
[TD]1[/TD]
[TD]1[/TD]
[TD]1[/TD]
[TD]1[/TD]
[TD]1[/TD]
[TD]1[/TD]
[TD]1[/TD]
[/TR]
[TR]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD]TOTAL[/TD]
[/TR]
</tbody>[/TABLE]
TABLE 2
[TABLE="width: 576"]
<colgroup><col width="72" span="8" style="width:54pt"> </colgroup><tbody>[TR]
[TD="width: 72"][/TD]
[TD="width: 72"]SUNDAY[/TD]
[TD="width: 72"]MONDAY[/TD]
[TD="width: 72"]TUESDAY[/TD]
[TD="width: 72"]WEDNESDAY[/TD]
[TD="width: 72"]THURSDAY[/TD]
[TD="width: 72"]FRIDAY[/TD]
[TD="width: 72"]SATURDAY[/TD]
[/TR]
[TR]
[TD]A ASBURY[/TD]
[TD="align: right"]8[/TD]
[TD="align: right"]8[/TD]
[TD="align: right"]8[/TD]
[TD="align: right"]8[/TD]
[TD="align: right"]8[/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]N PATEL[/TD]
[TD][/TD]
[TD="align: right"]8[/TD]
[TD="align: right"]8[/TD]
[TD="align: right"]8[/TD]
[TD="align: right"]8[/TD]
[TD="align: right"]8[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]J JONES[/TD]
[TD="align: right"]8[/TD]
[TD="align: right"]8[/TD]
[TD="align: right"]8[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]L BULL[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD="align: right"]8[/TD]
[TD="align: right"]8[/TD]
[TD="align: right"]8[/TD]
[TD="align: right"]8[/TD]
[/TR]
[TR]
[TD]S MASON[/TD]
[TD="align: right"]8[/TD]
[TD="align: right"]8[/TD]
[TD="align: right"]8[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]J JHALLI[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD="align: right"]8[/TD]
[TD="align: right"]8[/TD]
[TD="align: right"]8[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]N KUMAR[/TD]
[TD="align: right"]8[/TD]
[TD="align: right"]8[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
</tbody>[/TABLE]
I have two different tables on two different sheets
Table 1 shows the a number if a person has worked on a particular day
Table 2 shows the amount of hours a person works on a particular day
what i need and would be totally greatfull for is a formula in table 1 which can total
the amount of hours worked which corresponds across the two sheets
so the answer in this case would be 80 totalling A Asbury & N Patel even though i have put a 1
in for N Patel on Sunday & Saturday
[TABLE="width: 647"]
<colgroup><col><col><col><col><col><col><col><col></colgroup><tbody>[TR]
[TD]NAME[/TD]
[TD]SUNDAY[/TD]
[TD]MONDAY[/TD]
[TD]TUESDAY[/TD]
[TD]WEDNESDAY[/TD]
[TD]THURSDAY[/TD]
[TD]FRIDAY[/TD]
[TD]SATURDAY[/TD]
[/TR]
[TR]
[TD]A ASBURY[/TD]
[TD]1[/TD]
[TD]1[/TD]
[TD]1[/TD]
[TD]1[/TD]
[TD]1[/TD]
[TD] [/TD]
[TD] [/TD]
[/TR]
[TR]
[TD]N PATEL[/TD]
[TD]1[/TD]
[TD]1[/TD]
[TD]1[/TD]
[TD]1[/TD]
[TD]1[/TD]
[TD]1[/TD]
[TD]1[/TD]
[/TR]
[TR]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD]TOTAL[/TD]
[/TR]
</tbody>[/TABLE]
TABLE 2
[TABLE="width: 576"]
<colgroup><col width="72" span="8" style="width:54pt"> </colgroup><tbody>[TR]
[TD="width: 72"][/TD]
[TD="width: 72"]SUNDAY[/TD]
[TD="width: 72"]MONDAY[/TD]
[TD="width: 72"]TUESDAY[/TD]
[TD="width: 72"]WEDNESDAY[/TD]
[TD="width: 72"]THURSDAY[/TD]
[TD="width: 72"]FRIDAY[/TD]
[TD="width: 72"]SATURDAY[/TD]
[/TR]
[TR]
[TD]A ASBURY[/TD]
[TD="align: right"]8[/TD]
[TD="align: right"]8[/TD]
[TD="align: right"]8[/TD]
[TD="align: right"]8[/TD]
[TD="align: right"]8[/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]N PATEL[/TD]
[TD][/TD]
[TD="align: right"]8[/TD]
[TD="align: right"]8[/TD]
[TD="align: right"]8[/TD]
[TD="align: right"]8[/TD]
[TD="align: right"]8[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]J JONES[/TD]
[TD="align: right"]8[/TD]
[TD="align: right"]8[/TD]
[TD="align: right"]8[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]L BULL[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD="align: right"]8[/TD]
[TD="align: right"]8[/TD]
[TD="align: right"]8[/TD]
[TD="align: right"]8[/TD]
[/TR]
[TR]
[TD]S MASON[/TD]
[TD="align: right"]8[/TD]
[TD="align: right"]8[/TD]
[TD="align: right"]8[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]J JHALLI[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD="align: right"]8[/TD]
[TD="align: right"]8[/TD]
[TD="align: right"]8[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]N KUMAR[/TD]
[TD="align: right"]8[/TD]
[TD="align: right"]8[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
</tbody>[/TABLE]
I have two different tables on two different sheets
Table 1 shows the a number if a person has worked on a particular day
Table 2 shows the amount of hours a person works on a particular day
what i need and would be totally greatfull for is a formula in table 1 which can total
the amount of hours worked which corresponds across the two sheets
so the answer in this case would be 80 totalling A Asbury & N Patel even though i have put a 1
in for N Patel on Sunday & Saturday