Formula to Summarize a List

[garylundblad]

Would there be a formula approach to summarizing a list of expenses by department? For example, I have a simple tool that divides up a total expense by any number of departments that need to share the expense. It would be great if there was a fairly simple way to have a summary section that displays the total for each department. So the formula would need to go through the list looking for a unique number, pull that department number, and then in the next column add up all instances of that department. Attached is the workbook for reference. It's a bit difficult to describe what I'm looking for, but suffice it to say I would like to create the summary section off to the right that I've done manually. I'm thinking I've seen a way to approach this type of thing before, but I don't recall where I saw it or how they did it.

Thank you!

Gary

 

[Nebu]

Hi:

Pull a pivot table.

Thanks

 

[garylundblad]

Thank you! That is certainly one way of doing it, although it makes it so I can't protect the worksheet and still make the pivot table refreshable. There are portions that I'd prefer to lockdown, but it might not be necessary. Thank you- I had forgotten about using a pivot table.

Gary