My solution would be a pivot table, I think. But I've also used DBSUM for exactly such a task.
It's not basic use of Excel. Consider it intermediate. Surely not advanced.
Kees
Hello,
I have departments listed in a drop down box on an expense report. Can I have the spreadsheet automatically calculate the total per department somehow?
Each line gives the option for the department via a dropdown. I'd like those totals to be added at the bottom of the sheet to show the total to allocate per department.
Thanks!!!

Chowhound
Comic Vine
GameFAQs
GameSpot
Giant Bomb
TechRepublic