Need assistance with sumifs formula

[kamjam]

Could someone help me with formula , I don't use excel often and after watchin multiple YouTube videos I still can't get the formula right . 

So I need find amount for each supplier on mktg journal tab (column D) in P9 (column E), and bring the amount from the mktg tab . 

[#2 · Accepted solution]

Hi @kamjam 

in E3:

=SUMPRODUCT((mktg!D$2:T$2=D3)*(mktg!B$3:B$14=E$2)*mktg!D$3:T$14)

[#3]

omg thank you so much !

[#4]

Glad I could help & Thanks for posting back