I need some help trying to sum totals for different events based on horizontal and vertical criteria. I've tried doing different combinations of SUMIFS INDEX MATCH formulas, including transposing the data and using this one:

demo sheet with step by step formula explanation