Sum if error?

[krunk]

I posted this question in a different format but i still haven't found a solution. The purchase is to summ all of the smaller product's into a new category of "Other".

Currently, it is returned only the first "Other" so its giving me 3690 but it should find all the "Others" and give a 3472. Thoughts? Here is the current formula and data sheet.

IFERROR(VLOOKUP($B13,$S$136:$X$162,HLOOKUP(CONCATENATE($D$126,D$135),$N$120:$X$121,2,FALSE),FALSE),SUMIF($B$11:$B$28,"=Other",$L$11:$L$28))