Lookup I think
 

I have a list of Employee names belonging to different depts with hours
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!!




--
LouM

Lookup I think
 

You need SUMIF:

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

HTH
Kostis Vezerides

On Feb 25, 2:46 pm, LouM wrote:
I have a list of Employee names belonging to different depts with hours
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!!

--
LouM

Lookup I think
 

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

On Feb 25, 12:46*pm, LouM wrote:
I have a list of Employee names belonging to different depts with hours
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!!

--
LouM