Hi,
I am building a spending tracker and have a function that I can't quite work out.
Excel Function.PNG
In the image above, what I am trying to do is.. the left hand blue table will contain all the items that I have spent money on and will be categorised with an option from the drop down box.
In the table on the right for each category I want to calculate the combined value of all rows of items that fall under each category.
Is this possible? If so how would I do this?
Appreciate the help.
Bookmarks