sumif, index match (multiple??)

[Chloe1113]

Hey everyone ... first post and hoping someone can help
I have this formula and i want to amend it to include 2 more match criteria but i dont know how ....

=SUMIFS(INDEX('SKU REPORT'!$D:$AG,,MATCH($J$2,'SKU REPORT'!$D$4:$AG$4,0)),'SKU REPORT'!B:B,DATA!A:A,'SKU REPORT'!A:A,DATA!K:K)

can someone help? or suggest another formula i could use?

Im basically trying to sum a certain column if column a and columns k in my back up sheet match my front sheet and if in my back up sheet 3 different row lines match

PLEASE!!!!

 

[Gerald Higgins]

This topic has also been raised in this separate thread
https://www.mrexcel.com/forum/excel-questions/1100034-formula-doesnt-work.html

Might be best to reply there.

 

[Chloe1113]

sorry my first post and i didnt realise it had actually posted!