Results 1 to 5 of 5

Thread: Simple SUMIF function with INDEX/MATCH

  1. #1
    Seeker Paoloskie's Avatar
    Join Date
    Dec 2019
    Posts
    6
    Articles
    0
    Excel Version
    Excel 2016

    Cool Simple SUMIF function with INDEX/MATCH



    Register for a FREE account, and/
    or Log in to avoid these ads!

    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

    Click image for larger version. 

Name:	Excelguru1.jpg 
Views:	96 
Size:	56.5 KB 
ID:	9497


























    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.

    Click image for larger version. 

Name:	Excelguru2.jpg 
Views:	93 
Size:	74.3 KB 
ID:	9498























    Paolo

  2. #2
    Administrator AliGW's Avatar
    Join Date
    Nov 2015
    Location
    Ipswich, Suffolk, England
    Posts
    1,338
    Articles
    0
    Excel Version
    Office 365 Subscription
    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.
    Ali
    Enthusiastic self-taught user of MS Excel!

  3. #3
    Acolyte caabyyc's Avatar
    Join Date
    Dec 2014
    Location
    Burnaby/Calgary
    Posts
    31
    Articles
    0
    Excel Version
    2016

    Smile

    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
    Last edited by AliGW; 2019-12-17 at 08:19 AM. Reason: Please don't quote unnecessarily!

  4. #4
    Seeker Paoloskie's Avatar
    Join Date
    Dec 2019
    Posts
    6
    Articles
    0
    Excel Version
    Excel 2016
    Thank you sir. I will try as soon as I get home. Happy holidays to you.

    Paolo

  5. #5
    Seeker Paoloskie's Avatar
    Join Date
    Dec 2019
    Posts
    6
    Articles
    0
    Excel Version
    Excel 2016
    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
  •