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

1. ## 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!

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

MAXIF, MINIF functions

3. ## 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. ## 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.

5. ## 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.

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

#### 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