# Thread: Simple SUMIF function with INDEX/MATCH

1. ## 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

2. 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.

3. 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

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

Paolo

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

Paolo

#### Posting Permissions

• You may not post new threads
• You may not post replies
• You may not post attachments
• You may not edit your posts
•