Excel SumProduct Formula

[rizmomin]

Hi:

I have sheet1 with data as follows:

Employee Names starts in Row1 from cell E1, F1,G1, H1, and so on


Column B, row 3 to 26 Start Date
Column C, row 3 to 26 End Date


Column E, row 3 to 26 Employee_A Total hours worked
Column F, row 3 to 26 Employee_B Total hours worked
Column G, row 3 to 26 Employee_C Total hours worked
Column H, row 3 to 26 Employee_D Total hours worked
Column I, row 3 to 26 Employee_E Total hours worked

and so on....

Now i have summary sheet where i need the above data as follows:

Summary sheet will have :
C2 = START DATE
C3 = END DATE

Employees name will be listed in C6 thru C50.

Depending on START DATE and END DATE, i like to get Total hours worked for each
employee in Cell D6 thru D50

I would appreciate if excel formula would do the task.

Thanks a lot for helping.....and let me know if you have any questions.

RM