SUMIFS Value! Error

[Ubayd94]

Hi Guys.

So Basically i want to use the SUMIFS function to help me update stock records based on 3 criteria
1. Item Code
2. Colour
3. Size

I have tried to do this, following all the steps correctly but getting a VALUE! error instead

I really need your help guys

I am attaching my excel file to this thread
Any help regarding this would be highly appreciated

THANKSSS

[davesexcel]

If you have D2:D17 then you need A2:A17, not A2:A21

[sandy666]

The Criteria_range argument must contain the same number of rows and columns as the Sum_range argument.

[JohnTopley]

Try

=SUMIFS(Sales!$D:$D,Sales!$A:$A,Sheet1!$A$2,Sales!$C:$C,Sheet1!$C2)

"Size" criteria omitted in your formula