Results 1 to 2 of 2

Thread: Summing up results from index, match

  1. #1
    Neophyte afika's Avatar
    Join Date
    Nov 2021
    Excel Version

    Summing up results from index, match

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

    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
    Excel Version
    How about

Posting Permissions

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