Single Column Criteria for Row, Mutliple Columns to sum, Sum with Index Matching

[darpodo]

I would like to sum within range all values that match a single column criteria for the sum row along with multiple columns that will indicate which specific cells within the row to sum.

My formula:
=SUM(INDEX(RAW!B4:DF137,MATCH(A3,RAW!A4:A137,0),0):INDEX(RAW!B4:DF137,MATCH(A3,RAW!A4:A137,0),MATCH(B2,RAW!B3:DF3,0)))

This is only bringing a sum of the entire row within the range. I want to only include cells within the row that match a column criteria. Is this possible?

Using this table below as an example, I want my formula to add up by row '1st Row Unique ID' and then columns 'Target Column' to give a sum of 1,050. The empty columns are intentional.

xyz

Team Descriptions

Target Column

Column 2

Column 3

Column 4

Column 5

Column 6

Target Column

Column 2

Column 3

Column 4

Column 5

Column 6

1st Row Unique ID

Team 1

500

54

33

435

44

65

550

22

54

33

333

44

2nd Row Unique ID

Data in this row ->

3rd Row unique ID

Data in this row ->

[daffodil11]

SUMPRODUCT is much shorter and is designed to handle crossing ranges.

=SUMPRODUCT((RAW!A4:A137=A1)*(RAW!B3:DF3=B2)*(RAW!B4:DF137))