Hello, I am trying to simplify a works rota. What I want to do is a final calculation of a single person's hours.To do this I want to check a column with the different workers names in it. If for e.g. Monday 1st has "bob" working, then i want to add the figure in the hours worked colum together to give a sum total for the month. The final monthly hours sum will check for every occurence of "bob" and add the corresponding hours worked.
So if "bob" is in a cell, take the number in the adjacent cell (e.g. 8 hours) and add it to every occurrence of "Bob" for the month.
A B
1 Hours Person
2 8 Tom
3 6 Bob
4 6 Ray
5 8 Bob
6 9 Mike
7 8 bob
Worker Bob hours worked = 22
if CELL F50(for e.g.)="bob" then check column B for "bob" and add every corresponding cell from column A to give the answer in CELL F51(for e.g.)
This being a first time post I hope i have explained well enough.
Thanks for any replies.
Bookmarks