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.

6	RSXF2 LED P3 40K AWFD MVOLT IS PER7 DDBXD
8	RSXF1 LED P4 40K WFL MVOLT IS FAO DBLXD
5	RSX1 LED P1 50K R3 MVOLT IS DWHXD
1	RSXF1 LED P4 40K AWFD MVOLT RPA DDBXD
5	RSXF1 LED P3 40K AWFD MVOLT IS DDBXD

<tbody>
</tbody>

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.

Comp	Color	Qty needed
IS	DDBXD	11
IS	DBLXD	8
IS	DWHXD	5
RPA	DDBXD	1
PER7	DDBXD	6

<tbody>
</tbody>

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))