+ Reply to Thread
Results 1 to 9 of 9

sumif with dynamic value range

  1. #1
    Registered User
    Join Date
    05-18-2013
    Location
    delhi
    MS-Off Ver
    Excel 2003
    Posts
    3

    sumif with dynamic value range

    help me put sum if formula in excel file. The formula should change the value range to be picked depending upon variable given in d1 to g1 in sheet 1.
    Attached Files Attached Files

  2. #2
    Administrator FDibbins's Avatar
    Join Date
    12-29-2011
    Location
    Duncansville, PA USA
    MS-Off Ver
    Excel 2000/3/7/10/13/16/365
    Posts
    52,242

    Re: sumif with dynamic value range

    Hi and welcome to the forum :0

    Will you always want to add all columns on sheet2? Or will there be times when you only want 2 or 3 of the columns?
    1. Use code tags for VBA. [code] Your Code [/code] (or use the # button)
    2. If your question is resolved, mark it SOLVED using the thread tools
    3. Click on the star if you think someone helped you

    Regards
    Ford

  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: sumif with dynamic value range

    Will the columns being entered in D1:G1 always comprise a contiguous range?

    For example, will you ever do something like this:

    D1 = NS03
    E1 = NS36
    F1 = empty cell
    G1 = empty cell
    Biff
    Microsoft MVP Excel
    Keep It Simple Stupid

    Let's Go Pens. We Want The Cup.

  4. #4
    Administrator FDibbins's Avatar
    Join Date
    12-29-2011
    Location
    Duncansville, PA USA
    MS-Off Ver
    Excel 2000/3/7/10/13/16/365
    Posts
    52,242

    Re: sumif with dynamic value range

    lol is there an cho in here Tony?

  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: sumif with dynamic value range

    I have a slow internet connection.

  6. #6
    Registered User
    Join Date
    05-18-2013
    Location
    delhi
    MS-Off Ver
    Excel 2003
    Posts
    3

    Re: sumif with dynamic value range

    I would be required to add all columns in sheet 2

  7. #7
    Administrator FDibbins's Avatar
    Join Date
    12-29-2011
    Location
    Duncansville, PA USA
    MS-Off Ver
    Excel 2000/3/7/10/13/16/365
    Posts
    52,242

    Re: sumif with dynamic value range

    If you only want the total, you dont need to sum the values - again. Just reference them...
    =INDEX(Sheet2!$F:$F,MATCH(Sheet1!B7,Sheet2!$A:$A,0),1)
    copied down

  8. #8
    Registered User
    Join Date
    05-18-2013
    Location
    delhi
    MS-Off Ver
    Excel 2003
    Posts
    3

    Re: sumif with dynamic value range

    I would be required to calculate for each of in variable in sheet 2 and a not just rirsk

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

    Re: sumif with dynamic value range

    It looks like you already have a category total on sheet2. Can't you just do a lookup for the total as FDibbins suggested?

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

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