I have a table on sheet 1 with date, item, amount and category. Eg. 01/01 "Yogurt" "$5" "grocery" 01/02 "Movie tickets" "$11" "entertainment"
I want to be able to see how much I spend on each category in sheet 2. Sort of like all my categories in a row and underneath them would be the total amount spent in a month on them. I don't want to use a pivot table because that doesn't update itself as I update data in sheet 1. I want excel to be able to identify each category as I use it in sheet 1 and then update in the respective column on sheet 2.
So what formula can I use? Or do I just resort to pivot table at the end of the month?