+ Reply to Thread
Results 1 to 5 of 5

sum using indirect index match

  1. #1
    Forum Contributor
    Join Date
    12-23-2007
    Location
    chennai india
    MS-Off Ver
    2010
    Posts
    133

    sum using indirect index match

    i am using formula
    IFERROR(SUM(INDEX(INDIRECT("'"&A2&"'!$C$1:$C$7"),0,MATCH(B2,(INDIRECT("'"&A2&"'!$a$1:$a$7")),0))),0)
    indirect represents sheetname. Greatful for your help
    Attached Files Attached Files

  2. #2
    Forum Expert
    Join Date
    12-11-2011
    Location
    Netherlands
    MS-Off Ver
    office 365
    Posts
    2,994

    Re: sum using indirect index match

    =IFERROR(SUMIF(INDIRECT("'"&A1&"'!$a$1:$a$20"),B1;INDIRECT("'"&A1&"'!$b$1:$b$20")),"")

    Try this formula
    Willem
    English is not my native language sorry for errors
    Please correct me if I'm completely wrong

  3. #3
    Forum Guru Tony Valko's Avatar
    Join Date
    12-31-2011
    Location
    Pittsburgh
    MS-Off Ver
    2002, 2007:2013
    Posts
    18,890

    Re: sum using indirect index match

    Try this...

    Data Range
    A
    B
    C
    1
    1104
    a
    1
    2
    1104
    b
    7
    3
    1104
    c
    9
    4
    1104
    d
    4
    5
    1104
    e
    0
    6
    1104
    f
    0
    7
    1104
    g
    7
    8
    1204
    a
    11
    9
    1204
    b
    0
    10
    1204
    c
    0
    11
    1204
    d
    14
    12
    1204
    e
    40
    13
    1204
    f
    16
    14
    1204
    g
    17
    15
    ------
    ------
    ------


    This formula entered in C1 and copied down:

    =IFERROR(SUMIF(INDIRECT("'"&A1&"'!A:A"),B1,INDIRECT("'"&A1&"'!B:B")),"")
    Biff
    Microsoft MVP Excel
    Keep It Simple Stupid

    Let's Go Pens. We Want The Cup.

  4. #4
    Forum Contributor
    Join Date
    12-23-2007
    Location
    chennai india
    MS-Off Ver
    2010
    Posts
    133

    Re: sum using indirect index match

    Tony Valko answer was correct. It lookd tough but he gave easy solution. Thank you. I am just tracing solved button but could not locate it.

  5. #5
    Forum Guru Tony Valko's Avatar
    Join Date
    12-31-2011
    Location
    Pittsburgh
    MS-Off Ver
    2002, 2007:2013
    Posts
    18,890

    Re: sum using indirect index match

    You're welcome. Thanks for the feedback!

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. [SOLVED] Index - match - indirect
    By JAYZE in forum Excel Formulas & Functions
    Replies: 7
    Last Post: 03-30-2016, 12:09 PM
  2. Help with Index, indirect, and match
    By chachacharest in forum Excel Formulas & Functions
    Replies: 5
    Last Post: 07-08-2014, 05:08 PM
  3. Problem with INDEX, INDIRECT, MATCH, MATCH
    By JO505 in forum Excel General
    Replies: 5
    Last Post: 09-01-2011, 05:51 PM
  4. Index/Indirect/Match Help
    By robertsclark in forum Excel General
    Replies: 2
    Last Post: 04-20-2011, 10:24 AM
  5. Using INDEX/MATCH with indirect
    By jdpjtp910 in forum Excel Formulas & Functions
    Replies: 6
    Last Post: 11-15-2010, 11:39 AM
  6. Index, Indirect, Match
    By ruslan_adx in forum Excel General
    Replies: 1
    Last Post: 10-08-2009, 03:35 AM
  7. using index/match & Indirect
    By jwongsf in forum Excel Formulas & Functions
    Replies: 13
    Last Post: 02-14-2009, 10:14 PM

Bookmarks

Posting Permissions

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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1