Results 1 to 2 of 2

Thread: Summing up results from index, match

Hybrid View

Previous Post Previous Post   Next Post Next Post
  1. #1
    Neophyte afika's Avatar
    Join Date
    Nov 2021
    Posts
    1
    Articles
    0
    Excel Version
    365

    Summing up results from index, match

    Hi All, hope you are having a good day..

    I have used Index and match function to pick up data from a data base. However what I need is to sum up and values of multiple mathers.

    Below, in the left is the data base, in the right is the picked up values for 'GL1-Brand1-Jan'.
    But in the data base for 'Jan & Brand1' there are two GL1 values, 300 and 200, so I need to get the look up value sumed up to have the result of 500. (Formula used --> =INDEX($D$3:$F$7,MATCH($I3,$C3:$C7,0),MATCH(J$1&J$2,$D$1:$F$1&$D$2:$F$2,0)). Pls help, tahnks


    Jan Jan Jan Jan Jan Jan
    Brand1 Brand2 Brand3 Brand1 Brand2 Brand3
    GL1 300 500 300 GL1 300 500 300
    GL2 400 700 700
    GL3 500 400 900
    GL1 200 600 900
    GL2 100 300 200

  2. #2
    Conjurer Fluff's Avatar
    Join Date
    Sep 2018
    Posts
    136
    Articles
    0
    Excel Version
    O365
    How about
    =SUM(FILTER(FILTER($D$3:$F$7,$C$3:$C$7=$I3),($D$1:$F$1=J$1)*($D$2:$F$2=J$2)))

Posting Permissions

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