Add Data for Full and Partial week

[rizmomin]

Hello:

Please refer to attached excel file.

Row 2 (cell M2) onwards shows day of the week.
I need to add hours for each employee for partial and full week.
Week starts from Monday and ends on Sunday.
Hence I have manually added partial week data in column M and N in Cell G3:G13 and full week data in Column O thru U in cell H3:H13

I need a formula to do this automatically.

Please let me know if any questions.

Thank you

Riz Momin

[wfm007]

I have added a helper function

[daffodil11]

You could name each range and use Sumproduct to calculate the totals.

Select O3:U13, name it Week 2 in upper left

H3 =SUMPRODUCT(($B$3:$B$13=$B3)*(week2))

Then copy and paste it downwards.

Repeat for all weeks.

[rizmomin]

Hi wfm007:

Your solution will work great since you are giving week #'s.

Thank you so much for your great help.

Riz Momin