Sum with 2 Conditions Formula

[GimpyHand]

Hey, I've been struggling with creating a formula to sum a column based on 2 conditions.

I need to match the contents of 2 columns AND match the contents of another column against text in another column.

Details:

SUM Column C IF Column E value is found in Column B AND the text in Column A is found in Column F

 

[GimpyHand]

Consumables.xlsx
	A	B	C	D	E	F		H
1	WO	Part #	Qty		Part #	WO List		SUM
2	62053	ABC1234	5		LLCD552	11250, 55542, 77831
3	11250	CC4523	1		ABC1234	62531, 85592, 111500
4	62053	ABC1234	1		ABC1234	11563, 62053, 11351
Formula