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

[belmotodell]

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.

[table="width: 500, class: grid, align: center"]
[tr]
[td]XYZ[/td]
[td]Team Descriptions[/td]
[td][/td]
[td]Target Column[/td]
[td]Column 2[/td]
[td]Column 3[/td]
[td][/td]
[td]Column 4[/td]
[td]Column 5[/td]
[td]Column 6[/td]
[td][/td]
[td]Target Column[/td]
[td]Column 2[/td]
[td]Column 3[/td]
[td][/td]
[td]Column 4[/td]
[td]Column 5[/td]
[td]Column 6[/td]
[td][/td]
[td][/td]
[td][/td]
[/tr]
[tr]
[td]1st Row Unique ID[/td]
[td]Team 1[/td]
[td][/td]
[td]500[/td]
[td]10[/td]
[td]15[/td]
[td][/td]
[td]300[/td]
[td]20[/td]
[td]15[/td]
[td][/td]
[td]550[/td]
[td]12[/td]
[td]36[/td]
[td][/td]
[td]80[/td]
[td]12[/td]
[td]13[/td]
[td][/td]
[td][/td]
[/tr]
[tr]
[td]2nd Row Unique ID[/td]
[td]Data in this row->[/td]
[td][/td]
[td][/td]
[td][/td]
[td][/td]
[td][/td]
[td][/td]
[td][/td]
[td][/td]
[td][/td]
[td][/td]
[td][/td]
[td][/td]
[td][/td]
[td][/td]
[td][/td]
[td][/td]
[td][/td]
[td][/td]
[/tr]
[tr]
[td]3rd unique ID[/td]
[td]Data in this row->[/td]
[td][/td]
[td][/td]
[td][/td]
[td][/td]
[td][/td]
[td][/td]
[td][/td]
[td][/td]
[td][/td]
[td][/td]
[td][/td]
[td][/td]
[td][/td]
[td][/td]
[td][/td]
[td][/td]
[td][/td]
[td][/td]
[/tr]
[/table]

 

[belmotodell]

bump.

 

[mas123]

try to explain what you want in a simple language
and use examples