Track Total Grocery Expenses
I want to sum all expenses in my monthly bank export that are categorized as 'Groceries'.
=SUMIF(B2:B7,"Groceries",D2:D7) How it works: The SUMIF function works by checking each cell in the specified 'Category' range (B2:B7). If a cell's content exactly matches the criterion 'Groceries', the function then adds the corresponding value from the 'Amount' range (D2:D7) to its running total. This allows you to efficiently filter and sum specific types of expenses.
Data Setup
| Date | Category | Description | Amount |
|---|---|---|---|
| 2023-10-01 | Groceries | SuperMart | 55.20 |
| 2023-10-03 | Utilities | Electricity Bill | 75.00 |
| 2023-10-05 | Groceries | Local Market | 32.50 |
| 2023-10-08 | Transport | Gas Station | 40.00 |
| 2023-10-10 | Groceries | Online Grocer | 88.15 |
| 2023-10-12 | Dining Out | Restaurant | 60.00 |
Step-by-Step Guide
Open your monthly bank export or personal expense tracker in Excel.
Ensure your data has a column for 'Category' (e.g., Column B) and a column for 'Amount' (e.g., Column D).
In an empty cell where you want to see the total (e.g., F2), enter the formula: `=SUMIF(B2:B7,"Groceries",D2:D7)`
Press Enter to calculate the total sum of all transactions categorized as 'Groceries'.
Explore More
Calculate Monthly Car Loan Payments
I want to know how much I need to pay monthly for a $30,000 car loan over 5 years at 4% interest.
Calculate Days Until Savings Goal
I want to calculate the number of days remaining between today's date and my target vacation date.
Check if Expense Exceeds Budget
I need a formula that says 'Stop Spending' if my total monthly expenses are greater than my income, else 'Safe'.
List Monthly Expense Categories
I want to combine all the unique expense categories I spent money on this month into a single summary cell.