Forum Discussion
Referencing data from sheet 1 on sheet 2
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?
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?
wasiarizvi Consider using a pivot table. More about that in the link below.
