I am in the process of making a Budget for my Family. I would like to be able to make a list of everything we buy: e.x.
ROW A| ROW B | ROW C | Row D
Date | Amount| Type of purchase | Account
Jan 1| $12.00| Groceries | Visa Debit
Jan 2| $2.20 | Office Supplies | Credit card
Jan 3| $10.00| Groceries | Credit Card
Is there a way for me to have a cell that calculates the amount spent in each catagorie? (looks at row C for groceries and then returns the sum of all that was spent on groceries) I want to get totals for how much I spend in each category as well as from which account they are coming.