Hi,
I'm new to the forum and new to some of the powerful things you can do in Excel. I recently set up my own home based business and have been trying out lots of new functions in Excel to improve how we record our accounts information and analyse it quickly. But I've hit on a problem I can't solve so I'm hoping someone here can help me out.
I want to have an automatic summary analysis produced from my expenses data, based on which department I want to classify them to from a dropdown list. In the attached spreadsheet you'll see an example of what I mean. I'd like to program the spreadsheet so that when I enter a new expense and assign it to a department the summary boxes immediately fill in for me, so I don't have to do a manual calculation.
I've tried using the DSUM formula but can seem to make it select all the expenses related to the sales department and add them up. So I might not be using the right formula.
Any help at all would be greatly appreciated and will help me to improve my knowledge of Excel.
Thanks in advance.
Bookmarks