Referencing data from sheet 1 on sheet 2

Copper Contributor
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?
1 Reply