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!
Bookmarks