Rota

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.

Can you ask unrelated questions in a separate thread

How is your data laid out? can you upload a sample? or will the whole months data be laid out in Col A with Employees in B?

if everythings in the same row this will do it, assuming your range is A1:A49 for the hours and B1:B49 for the employee name

SUMIF(B2:B49,"Bob",A2:A49)

PS I typed "Bob" into the cell, you could have his name in a cell and refer to the cell instead

As long as the listed names in the Drop down are exactly the same as those in your employee list then that formula you posted should work. Just to clarify, you don't need to typ the cell A50 into the formula, just click on it. If you are typing it, don't use any quotes round it