+ Reply to Thread
Results 1 to 5 of 5

can a "MINIF" formula be built, equivalent to "SUMIFS"?

  1. #1
    Forum Contributor
    Join Date
    12-03-2008
    Location
    Key West, FL
    MS-Off Ver
    365 Apps for Enterprise
    Posts
    650

    can a "MINIF" formula be built, equivalent to "SUMIFS"?

    I have a spreadsheet with one column containing negative numbers.

    I'm trying to arrive at a solution which would be equivalent to a SUMIFS, but rather than a SUM of a range I need to get the MIN in the range.

    The attached sheet illustrates the problem. You can see where I've created a SUMIFS formula in the cell where I'd like to see a "MINIF" formula!

    Any thoughts?


    Thanks much!
    Attached Files Attached Files
    Last edited by jrtaylor; 10-22-2011 at 12:44 PM. Reason: solved

  2. #2
    Forum Guru (RIP) Marcol's Avatar
    Join Date
    12-23-2009
    Location
    Fife, Scotland
    MS-Off Ver
    Excel '97 & 2003/7
    Posts
    7,218

    Re: can a "MINIF" formula be built, equivalent to "SUMIFS"?

    Try this link
    MAXIF, MINIF functions
    If you need any more information, please feel free to ask.

    However,If this takes care of your needs, please select Thread Tools from menu above and set this topic to SOLVED. It helps everybody! ....

    Also
    اس کی مدد کرتا ہے اگر
    شکریہ کہنے کے لئے سٹار کلک کریں
    If you are satisfied by any members response to your problem please consider using the small Star icon bottom left of their post to show your appreciation.

  3. #3
    Forum Contributor
    Join Date
    12-03-2008
    Location
    Key West, FL
    MS-Off Ver
    365 Apps for Enterprise
    Posts
    650

    Re: can a "MINIF" formula be built, equivalent to "SUMIFS"?

    Thanks. I've been trying but the solutions offered on the links you provided involve just one condition, whereas I've got two.

    I've tried substituting AND for "IF" but no success so far.

    I'm currently trying a number of nested IF statements.

    Thanks

  4. #4
    Forum Guru (RIP) Marcol's Avatar
    Join Date
    12-23-2009
    Location
    Fife, Scotland
    MS-Off Ver
    Excel '97 & 2003/7
    Posts
    7,218

    Re: can a "MINIF" formula be built, equivalent to "SUMIFS"?

    Use nested ifs in the array formula
    In K10
    Please Login or Register  to view this content.
    Confirm with Ctrl+Shift+Enter not just Enter.
    Drag/Fill Down

    Because your dates also have times I'm not sure this will return the correct answer
    You may need to use this formula to ignore the time portion of the date values.
    Please Login or Register  to view this content.
    See the attached, have a look at the yellow C/F values (yellow), see how the list omits some values where the time is outwith the limits.
    Attached Files Attached Files

  5. #5
    Forum Contributor
    Join Date
    12-03-2008
    Location
    Key West, FL
    MS-Off Ver
    365 Apps for Enterprise
    Posts
    650

    Re: can a "MINIF" formula be built, equivalent to "SUMIFS"?

    Thanks! Between the two formulas I think this will work. I'll mark this one SOLVED.

    I appreciate your help.

+ 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