Minifs function

paul_russell77

Is there a function that will behave as a "Minifs" function? I need to cross reference a column on another sheet and return the minimum value based on a matching criteria.

Kerry St. Thomas

You can combine COLLECT (to evaluate your matching criteria) with MIN to get your desired result.

=MIN(COLLECT({the range to collect and evaluate MIN}, {criterion range 1}, criterion1, {criterion range 2}, criterion2…))

See more about COLLECT here; there are examples of this application on the page:
https://help.smartsheet.com/function/collect

Good luck!

Kerry St. Thomas

You can combine COLLECT (to evaluate your matching criteria) with MIN to get your desired result.

=MIN(COLLECT({the range to collect and evaluate MIN}, {criterion range 1}, criterion1, {criterion range 2}, criterion2…))

See more about COLLECT here; there are examples of this application on the page:
https://help.smartsheet.com/function/collect

Good luck!

paul_russell77

Thank you, that worked. I had something with the collect out of order. Thanks again