Formula to sum list with simular SKU

[foxtrapperscott]

I looking for a formula that will search a list of SKU that are similar and sum the sales totals in a cell with the Primary SKU. So a formula that looks for S650 in the data and gives the sum of all with similar SKU as the result. The example may be more helpful below to see what I'm trying to accomplish. Thanks for your help, I greatly appreciate it!


[TABLE="class: grid, width: 500"]
<tbody>[TR]
[TD]DATA[/TD]
[TD]SALES[/TD]
[TD][/TD]
[TD][/TD]
[TD]COMBINED SKU[/TD]
[TD]TOTAL SALES[/TD]
[/TR]
[TR]
[TD]S650[/TD]
[TD]2[/TD]
[TD][/TD]
[TD][/TD]
[TD]S650[/TD]
[TD]15[/TD]
[/TR]
[TR]
[TD]S650 IT4[/TD]
[TD]5[/TD]
[TD][/TD]
[TD][/TD]
[TD]S750[/TD]
[TD]9[/TD]
[/TR]
[TR]
[TD]S650 T4[/TD]
[TD]8[/TD]
[TD][/TD]
[TD][/TD]
[TD]S850[/TD]
[TD]8[/TD]
[/TR]
[TR]
[TD]S750[/TD]
[TD]9[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]S850[/TD]
[TD]3[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]S850 T4[/TD]
[TD]5[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
</tbody>[/TABLE]

 

[UniMord]

=SUMPRODUCT((LEFT(Table1[DATA], FIND(" ", Table1[DATA] & " ")-1)=[@[COMBINED SKU]])*Table1[SALES])

In addition to the solution I gave above, a friend of mine suggested, that if you were to create a helper column in Table1, which would append a space to each SKU, you can use a simpler formula:
=SUMIF(Table1[Helper], [@[COMBINED SKU]] & " *", Table1[SALES])