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!!!!
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!!!!