3 condition sum formula

Salamullah

Board Regular
Joined
Mar 28, 2011
Messages
221
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.


AAreaSourceJanFebMar
JanAImp121
ImpBImp124
CImp124
Aloc624
Bloc134
AImp134
Cloc222
Cloc222
AImp222

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

Some videos you may like

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
Joined
Oct 24, 2012
Messages
3,922
Office Version
  1. 365
Platform
  1. MacOS
not sure i fully understand what you are trying to achieve
can you give more examples
 

Fluff

MrExcel MVP, Moderator
Joined
Jun 12, 2014
Messages
46,077
Office Version
  1. 365
Platform
  1. Windows
Is this what you need
=SUMPRODUCT((B2:B10=A1)*(D1:F1=A2)*(C2:C10=A3),D2:F10)
 

Watch MrExcel Video

Forum statistics

Threads
1,108,633
Messages
5,523,995
Members
409,555
Latest member
TIPSAREA

This Week's Hot Topics

Top