Sumproduct to remove second stage calculation?

[Scotster]

Hi there, looking for some assistance in how to achieve a result without the added step. I have it in my head I can use Sumproduct but I may be wrong. Any assistance would be appreciated.

Apologies, I'm on a works laptop and I don't have the ability to download/install the plugin or even attach a file. I hope that's OK.

Below is an example of what I'm trying to achieve. Result1 and Result2 values are calculated using simple Sumif formulae:

=SUMIF($A$3:$A$14,$E3,$B$3:$B$14)

=SUMIF($D$3:$D$14,$H3,$F$3:$F$14)

I'm looking to achieve the second result without having a requirement for the first result. My attempt was to use an index/match but I don't believe this returns the multiple matches into the array, hence only resulting in the first value rather than the sum:

=SUMPRODUCT($B$3:$B$14*(($A$3:$A$14=INDEX($E$3:$E$14,MATCH($K3,$D$3:$D$14,0),1))))

					Result1			Result2		Sumproduct	Result Bypass
Code	Value		Plant	Code	Value		Result	Value		Result	Value
AAA	5		P1	AAA	5		P1	50		P1	5
AAB	10		P1	AAB	10		P2	20		P2	2
AAC	15		P1	AAC	15		P3	16		P3	1
AAD	20		P1	AAD	20
BBA	2		P2	BBA	2
BBB	4		P2	BBB	4
BBC	6		P2	BBC	6
BBD	8		P2	BBD	8
CCA	1		P3	CCA	1
CCB	3		P3	CCB	3
CCC	5		P3	CCC	5
CCD	7		P3	CCD	7

I'm no doubt missing something simple so any help appreciated.

 

[Scotster]

Typical, I hit post and then I solve it:

=SUMPRODUCT($B$3:$B$14*(VLOOKUP($A$3:$A$14,$D$3:$E$14,2,0)=$K3))

Happy if there are any other options though, in case there's a better way