I use Google Sheets to keep track of my expenses. The file currently consists of:
Sheet 1: "Expense Types"
Sheet 2: "2015 Details".
The first column of
Sheet 1 contains the list of admissible expense types, and each row in
Sheet 2 details one single expense: data, notes, type and amount.
I would like to create a new
Sheet 3: "2015 Summary" that would contain, on each row, a single expense type and the sum of all expenses of the given type. Moreover, I want this sheet to automatically update in case I add a new expense type on
Is it possible to do this using worksheet formulas or do I need to do some scripting?