SUMIFS/INDEX-MATCH based on criteria in 2 rows and 1 column

[longhorn_1b3]

I'm using Google Sheets. In another tab, I'm trying to match in the values (in the white part of the table) based on the three criteria. So for example, I'm wanting to match in the 0.2856... for criteria: Member #1, 1, A.

 

[Fluff]

Duplicate SUMIFS with 2 row and 1 column Google sheets

Please do not post the same question multiple times. All clarifications, follow-ups, and bumps should be posted back to the original thread.
Per forum rules, posts of a duplicate nature will be locked or deleted (rule 12 here: Forum Rules).