Possible sum/match/index formula problem

So my excel sheet attached shows members of my guild, the era they have advanced to, and a great building that produces goods called: Arc. I want to add the amount of goods that each member of my guild is producing into groups divided up into their respective era's (column I). I cant figure out the formula but I believe it would involve sum, index, and match. Please help!!