Sum - Index, Match, Match
Results 1 to 3 of 3

Thread: Sum - Index, Match, Match
Thanks Thanks: 0 Likes Likes: 0

  1. #1
    Board Regular
    Join Date
    Apr 2009
    Posts
    1,081
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default Sum - Index, Match, Match

    I am having some trouble using sum with Index, Match, Match.
    My Formula is =SUM(INDEX(Sheet1!$B$1:$R$50,MATCH('July 2018'!$B10,Sheet1!$B$1:$B$50,0),MATCH('July 2018'!$O$2,Sheet1!$B$1:$R$1,0)))

    I need to cross match two categories and where that information meets up, I need to sum.
    Thanks
    Excel 2007 & 2010

  2. #2
    Board Regular Rijnsent's Avatar
    Join Date
    Oct 2005
    Location
    Utrecht, Holland
    Posts
    1,012
    Post Thanks / Like
    Mentioned
    1 Post(s)
    Tagged
    0 Thread(s)

    Default Re: Sum - Index, Match, Match

    Hi psrs0810,
    I'm trying to understand your formula: you try to find cell C2 in the first row and B10 in Column B. Both of them can have multiple matches? Because when there is just 1 intersecting cell you'd just need a simple INDEX with 2 matches without a sum. Is that what you are looking for?
    Cheers,
    Koen
    You can't post attachments here, but you can help me helping you by posting a screen shot directly in your post with any of those tools.
    Otherwise use dropbox/google drive/etc to get your file accross (not preferred). For code, put it inside these tags: [ CODE][/CODE]. Do check the forum rules.
    Finally, please show that you made an effort to solve your problem: Yes, I like to help, but am not going to do your job.

  3. #3
    Board Regular
    Join Date
    Jul 2013
    Location
    CT, USA
    Posts
    200
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default Re: Sum - Index, Match, Match

    try this approach?
    #FFFFFF ;border: 1px solid;border-collapse: collapse; border-color: #BBB">#DAE7F5 " />#DAE7F5 ;text-align: center;color: #161120">
    ABCDEFGHIJKLMNO
    1JanFebMarAprMayJunJulAugSepOctNovDec
    2Paul121416182022242628303234Paul
    3George242628303234363840424446Jul
    4Ringo36384042444648505254565884
    5Paul485052545658606264666870

    #DAE7F5 ;color: #161120">Sheet6



    #FFFFFF " >
    Worksheet Formulas#FFFFFF ;border-collapse: collapse; border-color: #BBB">#DAE7F5 ;color: #161120">
    CellFormula
    #DAE7F5 ;color: #161120">O4=SUMPRODUCT((A2:A5=O2)*((B1:M1=O3)*(B2:M5)))


Some videos you may like

User Tag List

Tags for this Thread

Like this thread? Share it with others

Like this thread? Share it with others

Posting Permissions

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