sumifs with 2 sum ranges

[Salamullah]

Products	Source	Actuals​ <strike></strike>	Plan
a	Loc	40	50
b	Imp	50	30
c	Imp	10	20
d	loc	10	20

<tbody>
</tbody>

Actuals
Loc
a

Please share formula in cell A9 from the array A2:D5 with meeting condition in cell A6, A7 & A8.

In other words I am not able to find 2 sum ranges in SUMIFS formula

 

[MARZIOTULLIO]

	A​	B​	C​	D​
1​	Products	Source	Actuals	Plan
2​	a	Loc	40​	50​
3​	b	Imp	50​	30​
4​	c	Imp	10​	20​
5​	d	loc	10​	20​
6​
7​	Actuals	40​
8​	Loc
9​	a

<tbody>
</tbody>

B7=SUMPRODUCT((B2:B5&A2:A5=A8&A9)*(C1:D1=A7)*(C2:D5))

 

[Salamullah]

Good Many thanks MARZIOTULLIO