Hi everyone - I'm using Google Sheets and am trying to use a SUMIFS or INDEX-MATCH formula to pull in a value based on criteria in two rows and one column. See screenshot for layout of data (on the left) and desire output based on given criteria (on the right).
Capture.JPG