Lookup I think

[LouM]

I have a list of Employee names belonging to different depts with hour
worked. I want to add up the total hours for each dept.

Cell
A1 - A75 Employee name
B1 - B75 Dept (eg Sales, Warehouse, Office)
E1 - E75 Hours worked

I would like to return
Sales = Total Hours
Warehouse = Total Hours

Please help it is driving me mad!

 

[vezerid]

You need SUMIF:

=SUMIF(B1:B75,"Sales",E1:E75)

HTH
Kostis Vezerides

 

[Pete_UK]

Make a list of your different departments - Sales, Warehouse, Office
etc. Suppose this list is in coumn M, starting in M1. Then in N1 you
can put this formula:

=SUMIF(B1:B75,M1,E1:E75)

and copy this down the column for as many departments as listed in
column M.

Hope this helps.

Pete