Dear Excel-lent users,

Could you please help me with the following challenge ?

In Row 2 (B2:AC2) I have the numbers of the week starting from 1 till 28
In Column 1 (A3:A24) I have the names of the resources

Per week I fill in the hours per resources for different tasks, so one name
will occur multiple times in Column 1. The hours are filled in in the Area
B3:AC24.

Now I want to know per week how many hours 1 resource is booked.

Could you please help me with a formula to calculate this?

Thank you very much !!

Jaydubs !