Summing numerous entries per department into one total...

[apatreau]

So I have resources assign to a job, in that line item it shows their department listed from cell H5 down to H16

I have the total cost of that resource listed in cell K5 down to K16

I want to create a per department summery further down the spreadsheet. This formula should sum up like-departments that are shown in cells H5 - H16 and take the costs from cells K5 - K16 and provide me with a grand total per department.

thoughts?

 

[VoG]

Pivot Table?

 

[lenze]

The operative word is "Pivot Table"

lenze

 

[apatreau]

Ahhh yes, man I've always avoided pivot tables for some reason....I'll give it a shot.

did I sense some slight sarcasm in that response? Haha.

 

[Asator]

Learn them. Live them. Love them.