3 condition sum formula

[Salamullah]

Please help I need formula to bring result in cell A4 based on the change condition in A1, A2 & A3 from the array B1:F10.

A	Area	Source	Jan	Feb	Mar
Jan	A	Imp	1	2	1
Imp	B	Imp	1	2	4
	C	Imp	1	2	4
	A	loc	6	2	4
	B	loc	1	3	4
	A	Imp	1	3	4
	C	loc	2	2	2
	C	loc	2	2	2
	A	Imp	2	2	2

<colgroup><col width="64" style="width:48pt" span="6"> </colgroup><tbody>
</tbody>

 

[etaf]

not sure i fully understand what you are trying to achieve
can you give more examples

 

[Fluff]

Is this what you need
=SUMPRODUCT((B2:B10=A1)*(D1:F1=A2)*(C2:C10=A3),D2:F10)

 

[Marcelo Branco]

Try

=SUMIFS(INDEX(D2:F10,0,MATCH(A2,D1:F1,0)),B2:B10,A1,C2:C10,A3)

M.