SUM Best Formulae

[Excel-Access]

Hi

What is the best formulae to use?

I am trying to pull data into the customer tab from data tab.

It will look at the variables Division, Workstream, Lever and then apply the amount in Weighted Pipeline etc. from data tab

 

[Hui]

D2:
=INDEX(Data!D$2:D$16,MATCH($A2&$B2&$C2,Data!$A$2:$A$16&Data!$B$2:$B$16&Data!$C$2:$C$16,0)) Ctrl+Shift+Enter
Copy across then down

But my favourite is:
=SUMPRODUCT((Data!$D$2:$I$16)*((Data!$A$2:$A$16=$A2)*(Data!$B$2:$B$16=$B2)*(Data!$C$2:$C$16=$C2)*(Data!$D$1:$I$1=D$1)))
Copy across and down

 

[bosco_yip]

Perhaps,

In "Customer" sheet D2, formula copied across and down :

=IF($C2="","",SUMIFS(Data!D:D,Data!$A:$A,$A2,Data!$B:$B,$B2,Data!$C:$C,$C2))

Regards
Bosco

 

[Excel-Access]

Thank you Hui and Bosco for alternative solutions.