Simple SUMIF function with INDEX/MATCH

Hi there folks,

Thanks in advance. It's a pretty simple problem but I'm not getting any result. I would just like to sum the In Stock of a code from 'On Order' sheet (some products have 2 lines).

1) Figure 1




























2) Figure 2 - As you cansee, there are lines with a lot of location (I have 30 locations). For example, code ARTNGH81587-----NIK------1SZ should return 106 (57+49). I know SUMIFS and INDEX/MATCH will do the job. Please take note I don't have the newest version of Excel.

























Paolo

You just need SUMIF:

=SUMIF('On Order'!D,E4,'On Order'!F:F)

If this doesn't work, attach the workbook, not an image of it.

Two options here, at worksheet "Final"

H4=SUMIF('On order'!D:d,E4,'On order'!F:F) if get "#name", try option 2 as follow
H4=SUM(IF('On order'!$D$1:$D$1000=E4,'On order'!$F$1:$F$1000,"/")) hit "control,shift,enter" to run

Thank you sir. I will try as soon as I get home. Happy holidays to you.

Paolo

Thank you maam Ali. We'll update you if it works. Happy holidays to you.

Paolo