Lookup I think

L

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!
 
P

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
 
Top