I use Google Sheets to keep track of my expenses. The file currently consists of:Sheet 1: Expense TypesSheet 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 Sheet 1. Is it possible to do this using worksheet formulas or do I need to do some scripting?
Sum all expenses of a given type given a list of expense types in a separate sheet
google spreadsheets;google apps script;worksheet function