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