complex formula for gathering Monthly data

[Kram222]

Please help me write this data into my book:

I need to track the hours of people from different weeks(sheets) but also for the MONTH

I need a formula to track the person and gather the info onto for them for the whole month.

I have a formula for tracking the week (its under "actual hours" in the UTILITY sheet:
Formula:

=INDEX(INDIRECT("'"&$A76&"'!$D$361:$DA$361"),MATCH($C76,INDIRECT("'"&$A76&"'!$C$2:$DA$2"),0))

But it only tracks one specific cell for each teacher.

I need this new formula to track the DATES (column A) and SUM the "Facehours" (each teacher's 2nd column) for each teacher for the said month.

*NOTE: the total for each day, on the schedule, is right under the day eg: row 54, 105, 156, 207, 258, 309 and 360

This seems really hard for me! can anyone help?

Here is an example book

Attached Files

[vane0326]

Can you shows us on a sample worksheet where & what results you are expecting?

[Kram222]

Can you shows us on a sample worksheet where & what results you are expecting?

In my attached woorkbook there is a overtime sheet. the sum of all of the face hours for the said month would be entered in there, accordingly.

[vane0326]

In my attached woorkbook there is a overtime sheet. the sum of all of the face hours for the said month would be entered in there, accordingly.

I only see 6 worksheets.

1242
1243
1244
1245
Utility
Monthly Hours

There is no overtime worksheet.

[Kram222]

I only see 6 worksheets.

1242
1243
1244
1245
Utility
Monthly Hours

There is no overtime worksheet.

sorry my meaning was the monthly hours sheet

[vane0326]

sorry my meaning was the monthly hours sheet

Thanks!

In cell D3 should be 0.0 Right?
In cell D4 should be 37.50 Right?