Hi, I really wanted to try to figure this out on my own but I am getting frustrated lol

I have categories which all transactions fall under. However I don't like these categories (too many) so I created master categories holding them. I want to do a SUMIF type statement for each of the master categories, which would each hold multiple categories. I would do a SUMIFS statement, criteria being category 1, 2, 3 for master category 1 except that I have just a ridiculous amount of data - and each master category might be holding 20+ subcategories.

Does anyone know how to sum up the various transactions based on the master categories???

Thanks so much!

Excel Problem.xls