Roster Management

Good morning.

I have been toying with a roster sheet for sometime now and never quite made it do what I wanted and was wondering if somebody could point me in the right direction please. In short, what I am trying to do (aside from regrow my torn-out hair) is create a roster tool.
The file is attached here.

It's a 12 month calendar where a number of fictional clients are supported by a number of engineers, listed at the bottom of the page.
The amount of hours require to support each client is next to the client's name.

We would fill in the engineer who will attend the site in the left hand column of each month via a drop-down box.

Calculation 1:
Beside the engineer's name at the bottom (in green column) I'd like to tally up how many hours have been allocated to any one engineer against the list of (z) clients above. So, if engineer XX is listed against 3 clients, whose hours are 4, 8, and 3, then 15 would be recorded in that green column for that engineer.

Calculation 2:
In the yellow column under each month, Id like to tally up how many hours that engineer has been assigned for that month.

The idea is to allocate engineers to clients and get an instant picture of how many hours they have been allocated.

Have I muddied the waters?

Any help would be greatly appreciated. :-)

Cheers,
Greg

Hi Tsjallie,

Thanks for this. Really appreciated. Covers what i want to do.

Greg