# 3 condition sum formula

#### Salamullah

##### Board Regular
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>

### Excel Facts

How to show all formulas in Excel?
Press Ctrl+` to show all formulas. Press it again to toggle back to numbers. The grave accent is often under the tilde on US keyboards.

#### etaf

##### Well-known Member
not sure i fully understand what you are trying to achieve
can you give more examples

#### Fluff

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

#### Marcelo Branco

##### MrExcel MVP
Try

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

M.

Replies
2
Views
335
Replies
2
Views
322
Replies
5
Views
55
Replies
3
Views
59
Replies
3
Views
40