Hi guys,

I'm having a data table that contains various data from different date. I would like to sum all the data into the summary sheet which consolidate into yearly data. PLease help me out if you know how to come up with the formula like that. I'm trying INDEX, MATCH and SUMIFS functions but I don't know how to put all these formulas into one.

Attached is the file. SAMPLE.xlsx