INDIRECT formula cell reference
Page 2 of 2 FirstFirst 12
Results 11 to 17 of 17

Thread: INDIRECT formula cell reference
Thanks Thanks: 0 Likes Likes: 0

  1. #11
    New Member
    Join Date
    Apr 2018
    Posts
    24
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default Re: INDIRECT formula cell reference

    Quote Originally Posted by steve the fish View Post
    You need to be answering the question in post 6. I presume you are dragging right. So what is the formula you want in the cell next to the original to be? Put it here in exactly the same way as you did for the original formula but the cell to the right. I would need to know what needs to change from cell to cell.
    I answered above

    I need D6 to change to E6.

  2. #12
    New Member
    Join Date
    Apr 2018
    Posts
    24
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default Re: INDIRECT formula cell reference

    Quote Originally Posted by rlexcel101 View Post
    I answered above

    I need D6 to change to E6.
    last bump

  3. #13
    Board Regular
    Join Date
    Oct 2009
    Location
    Midlands, UK
    Posts
    7,509
    Post Thanks / Like
    Mentioned
    17 Post(s)
    Tagged
    3 Thread(s)

    Default Re: INDIRECT formula cell reference

    The reason I haven't replied is that you haven't given what I asked for. If I'm to know what you need I need to know exactly what that formula would look like if it was in the cell to the right in the same format as your opening post.

  4. #14
    New Member
    Join Date
    Apr 2018
    Posts
    24
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default Re: INDIRECT formula cell reference

    Quote Originally Posted by steve the fish View Post
    The reason I haven't replied is that you haven't given what I asked for. If I'm to know what you need I need to know exactly what that formula would look like if it was in the cell to the right in the same format as your opening post.
    So..

    =SUMPRODUCT(SUMIF(INDIRECT(""&data&"!"&"A6:A6"),$B12,INDIRECT(""&data&""!"&"D6:D6")))

    Is my current formula.

    -A6:A6 represents the lookup in each sheet
    -$B12 represents the criteria on the sheet where formula is
    -D6:D6 represents the sum values on each sheet tab

    So basically I need the ability for the D6:D6 to become cell references where I can drag and they become E6:E6, F6:F6, and then If dragged down then E7:E7, etc

    Does that help?

  5. #15
    Board Regular
    Join Date
    Oct 2009
    Location
    Midlands, UK
    Posts
    7,509
    Post Thanks / Like
    Mentioned
    17 Post(s)
    Tagged
    3 Thread(s)

    Default Re: INDIRECT formula cell reference

    So column A remains column A as you drag right?

    =SUMPRODUCT(SUMIF(INDIRECT("'"&data&"'!A"&ROWS($A$1:A1)+5),$B12,INDIRECT("'"&data&"'!"&ADDRESS(ROWS($A$1:A1)+5,COLUMNS($A$1:A1)+3))))

  6. #16
    New Member
    Join Date
    Apr 2018
    Posts
    24
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default Re: INDIRECT formula cell reference

    Quote Originally Posted by steve the fish View Post
    So column A remains column A as you drag right?

    =SUMPRODUCT(SUMIF(INDIRECT("'"&data&"'!A"&ROWS($A$1:A1)+5),$B12,INDIRECT("'"&data&"'!"&ADDRESS(ROWS($A$1:A1)+5,COLUMNS($A$1:A1)+3))))
    Thank you!

    This worked. My next goal is to make this match off a drop down which I have no clue how lol ideally would like to match the drop down name against the same name on sheet tab.

  7. #17
    New Member
    Join Date
    Apr 2018
    Posts
    24
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default Re: INDIRECT formula cell reference

    =SUMPRODUCT(SUMIF(INDIRECT("'"&data&"'!A"&ROWS($A$1:A1)+5),$B12,INDIRECT("'"&data&"'!"&ADDRESS(ROWS($A$1:A1)+5,COLUMNS($A$1:A1)+3))))


    So this might get crazy with above but is there a way to do a IF/MATCH type addition to this formula off a drop down?

    So in this case:

    - In C5 I have my drop down list and each names are identical to the tabs that are being rolled up. Say I just want to choose from drop for that specific name and then a “Total” drop down option as well?

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
  •