+ Reply to Thread
Results 1 to 9 of 9

Dynamic SUMIF(S) "sum range"

  1. 12-13-2013, 05:12 AM #1
    epsiloni
    epsiloni is offline
    Registered User
    Join Date
    12-13-2013
    Location
    london
    MS-Off Ver
    Excel 2010
    Posts
    10

    Dynamic SUMIF(S) "sum range"

    Hi guys,

    I'm trying to do a dynamic "sum range" of the SUMIF, or SUMIFS function. Please, look at the attached file or here at the image.

    Capture.PNG

    Please, help...
    Attached Files Attached Files
    Reply With QuoteRegister To Reply
  2. 12-13-2013, 05:17 AM #2
    Fotis1991
    Fotis1991 is offline
    Forum Expert Fotis1991's Avatar
    Join Date
    10-11-2011
    Location
    Athens(The homeland of the Democracy!). Greece
    MS-Off Ver
    Excel 1997!&2003 & 2007&2010
    Posts
    13,744

    Re: Dynamic SUMIF(S) "sum range"

    Do you mean?
    Formula: copy to clipboard 
    Please Login or Register  to view this content.
    Regards

    Fotis.

    -This is my Greek whisper to Europe.

    --Remember, saying thanks only takes a second or two. Click the little star * below, to give some Rep if you think an answer deserves it.

    Advanced Excel Techniques: http://excelxor.com/

    --KISS(Keep it simple Stupid)

    --Bring them back.

    ---See about Acropolis of Athens.

    --Visit Greece.
    Reply With QuoteRegister To Reply
  3. 12-13-2013, 05:24 AM #3
    epsiloni
    epsiloni is offline
    Registered User
    Join Date
    12-13-2013
    Location
    london
    MS-Off Ver
    Excel 2010
    Posts
    10

    Re: Dynamic SUMIF(S) "sum range"

    yes, something like this, but I want each time I change the month drom the drop down menu, to change the column which is summed.
    Reply With QuoteRegister To Reply
  4. 12-13-2013, 05:28 AM #4
    epsiloni
    epsiloni is offline
    Registered User
    Join Date
    12-13-2013
    Location
    london
    MS-Off Ver
    Excel 2010
    Posts
    10

    Re: Dynamic SUMIF(S) "sum range"

    Yep!!! It worked now, I just changed last array to get all of the months, the first row is doubled (two identical accounts) so I deleted it... anyway, it's:

    Formula: copy to clipboard 
    Please Login or Register  to view this content.


    Thanks a lot Fotis1991 !!!
    Reply With QuoteRegister To Reply
  5. 12-13-2013, 05:34 AM #5
    Fotis1991
    Fotis1991 is offline
    Forum Expert Fotis1991's Avatar
    Join Date
    10-11-2011
    Location
    Athens(The homeland of the Democracy!). Greece
    MS-Off Ver
    Excel 1997!&2003 & 2007&2010
    Posts
    13,744

    Re: Dynamic SUMIF(S) "sum range"

    You are welcome and thanks for the feedback.

    As that takes care of your original question, please select Thread Tools from the menu link above and mark this thread as SOLVED,as per Forum Rule #9. Thank you.

    Also, as a new member of the forum, you may not be aware that you can thank those who have helped you by clicking the small star icon located in the lower left corner of the post in which the help was given. By doing so you can add to the reputation(s) of those who helped.
    Reply With QuoteRegister To Reply
  6. 12-13-2013, 05:47 AM #6
    epsiloni
    epsiloni is offline
    Registered User
    Join Date
    12-13-2013
    Location
    london
    MS-Off Ver
    Excel 2010
    Posts
    10

    Re: Dynamic SUMIF(S) "sum range"

    Thank you, I'll do the both.
    Reply With QuoteRegister To Reply
  7. 12-15-2013, 03:10 AM #7
    epsiloni
    epsiloni is offline
    Registered User
    Join Date
    12-13-2013
    Location
    london
    MS-Off Ver
    Excel 2010
    Posts
    10

    Re: Dynamic SUMIF(S) "sum range"

    Hi again guys,

    Now I'm trying to improve the functionality of the file attached above.
    I've attached the file again with another drop-down menu. What I'm trying to do is to have a sum of
    all the months between the two months indicated in the drop down menu.
    For example by picking two months from the drop down menus, I want to know the sum of the values between Jan-Mar (Jan, Feb and Mar), or for example Jul-Oct (Jul,Aug,Sep and Oct)...

    I've tried to combine SUMPRODUCT with INDEX and MATCH but it doesn't work.

    Any ideas?...
    Attached Files Attached Files
    Reply With QuoteRegister To Reply
  8. 12-15-2013, 04:32 AM #8
    Debraj Roy
    Debraj Roy is offline
    Forum Expert Debraj Roy's Avatar
    Join Date
    09-27-2012
    Location
    New Delhi,India
    MS-Off Ver
    Excel 2013
    Posts
    1,469

    Re: Dynamic SUMIF(S) "sum range"

    Try this.. in V4..

    Formula: copy to clipboard 
    Please Login or Register  to view this content.
    Last edited by Debraj Roy; 12-15-2013 at 04:41 AM.
    Regards!
    =DEC2HEX(3563)

    If you like someone's answer, click the star to give them a reputation point for that answer...
    Reply With QuoteRegister To Reply
  9. 12-15-2013, 04:33 AM #9
    Pepe Le Mokko
    Pepe Le Mokko is offline
    Forum Expert Pepe Le Mokko's Avatar
    Join Date
    05-14-2009
    Location
    Belgium
    MS-Off Ver
    O365 v 2504
    Posts
    13,620

    Re: Dynamic SUMIF(S) "sum range"

    Hi
    it would be better to start a new thread with this new question, eventually referring to this thread.
    How to paste Power Query code ( by Olly)
    Reply With QuoteRegister To Reply
+ Reply to Thread
« Previous Thread | Next Thread »

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. How to check if a range of cells contains the word "unresponsive" and return "yes" or "no"
    By benitopjuarez in forum Excel Formulas & Functions
    Replies: 5
    Last Post: 01-23-2014, 11:02 AM
  2. [SOLVED] date range in " sumif " or sumproduct "
    By Samir Alamad in forum Excel Formulas & Functions
    Replies: 5
    Last Post: 11-22-2012, 09:23 AM
  3. Performing "SUMIF" where "range" & criteria" are texts
    By joseedua in forum Excel General
    Replies: 1
    Last Post: 02-11-2010, 01:09 PM
  4. use variable in Workbooks("book1").Worksheets("sheet1").Range("a1"
    By Luc in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 09-28-2005, 04:05 PM
  5. [SOLVED] SUMIF - Range name to used for the "sum_range" portion of a SUMIF function
    By Oscar in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 01-11-2005, 07:06 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

Forum Rules


Search Engine Friendly URLs by vBSEO 3.6.0 RC 1