Forum Discussion
Sum Formula
Hey Everyone! So Im working on a budget for myself in excell and have a table with all my expenses, I want to try and find the totals of specific items in my budget, for example i have categories of ...
Let's say expenses are in D2:D100 and the corresponding categories in E2:E100.
Option 1:
Enter a category in - say - M2.
The total for that category is
=SUMIFS($E$2:$E$100, $D$2:$D$100, M2)
This can be filled down if you have more categories in M3 etc.
Option 2:
Create a pivot table based on the data.
Add the Category field to the Rows area and the Expenses field to the Values area.