I am creating a budget that has different expenses on one worksheet (Expense_Overview). On another worksheet, I have a list of expenses (Expense_Detail) I am entering that are categorized based on a data validation criteria I set via a list of items. I would like for the Actual Expense column in the Expense_Overview to tally the total
Expense Category based on the data in Expense_Detail. Eg, I want to know the total of all the
I want to avoid pivot tables if possible. I am not comfortable with them, and I am hoping a simple SUMIF line will accomplish this.