I have table of transactions with categories (let's say 1-5) and assigned dollar values, and another table with a list of each category. I want to sum up all the matching categories from Table 1 with the result in each row of table 2.
Table 1 (list of transactions)
Table 2 (sum of transactions for each category)
The actual Table 2 I'm working with has many rows and is constantly changing, so I don't want to fill a formula in each cell (Something like
=QUERY(A:B,"Select sum(B) where A = 'C' LABEL sum(B) ''") would work in that case). I'm thinking something like an ARRAYFORMULA or something with INDEX/FILTER/VLOOKUP that can fill the entire column. Help!