Formula to sum different objects depending on criteria

[Joe Rdz]

Hi, I've been trying to achieve something since yesterday but I haven't had any luck yet. Here's what's going on.

[TABLE="width: 388"]
<tbody>[TR]
[TD]6[/TD]
[TD]RSXF2 LED P3 40K AWFD MVOLT IS PER7 DDBXD[/TD]
[/TR]
[TR]
[TD]8[/TD]
[TD]RSXF1 LED P4 40K WFL MVOLT IS FAO DBLXD[/TD]
[/TR]
[TR]
[TD]5[/TD]
[TD]RSX1 LED P1 50K R3 MVOLT IS DWHXD[/TD]
[/TR]
[TR]
[TD]1[/TD]
[TD]RSXF1 LED P4 40K AWFD MVOLT RPA DDBXD[/TD]
[/TR]
[TR]
[TD]5[/TD]
[TD]RSXF1 LED P3 40K AWFD MVOLT IS DDBXD[/TD]
[/TR]
</tbody>[/TABLE]

I have those descriptions, with a quantity to their left, as you can see there's DDBXD, DBLXD, DWHXD at the very end of the sentence. What I basically want is a formula that will let me know how many components I need (In this case, how many "IS", "PER7", "RPA") based on their color.

For example, as a result I would like something like this.

[TABLE="width: 214"]
<tbody>[TR]
[TD]Comp[/TD]
[TD]Color[/TD]
[TD]Qty needed[/TD]
[/TR]
[TR]
[TD]IS[/TD]
[TD]DDBXD[/TD]
[TD="align: right"]11[/TD]
[/TR]
[TR]
[TD]IS[/TD]
[TD]DBLXD[/TD]
[TD="align: right"]8[/TD]
[/TR]
[TR]
[TD]IS[/TD]
[TD]DWHXD[/TD]
[TD="align: right"]5[/TD]
[/TR]
[TR]
[TD]RPA[/TD]
[TD]DDBXD[/TD]
[TD="align: right"]1[/TD]
[/TR]
[TR]
[TD]PER7[/TD]
[TD]DDBXD[/TD]
[TD="align: right"]6[/TD]
[/TR]
</tbody>[/TABLE]


Would appreciate any help on this, thanks!

 

[Fluff]

How about

Excel 2013/2016
	A	B	F	G	H	I
1				Comp	Color	Qty needed
2	6	RSXF2 LED P3 40K AWFD MVOLT IS PER7 DDBXD		IS	DDBXD	11
3	8	RSXF1 LED P4 40K WFL MVOLT IS FAO DBLXD		IS	DBLXD	8
4	5	RSX1 LED P1 50K R3 MVOLT IS DWHXD		IS	DWHXD	5
5	1	RSXF1 LED P4 40K AWFD MVOLT RPA DDBXD		RPA	DDBXD	1
6	5	RSXF1 LED P3 40K AWFD MVOLT IS DDBXD		PER7	DDBXD	6
Sheet2

Cell Formulas
Range	Formula
I2	=SUMPRODUCT((ISNUMBER(SEARCH(G2,B$2:B$6)))*(ISNUMBER(SEARCH(H2,B$2:B$6))),(A$2:A$6))