In other words, we want the min valueafterapplying multiple criteria.
The easiest way to solve this problem is with the MINIFS function.
Each method is explained below.
Excel Table
For convenience, all data is in anExcel Tablenameddatain the range B5:D16.
If you are new to Excel Tables,this article provides an overview.
All conditions must be true in order for value to be considered.
In other words, MINIFS will not treat empty cells that meet criteria as zero.
On the other hand, MINIFSwillreturn zero (0) if no cells match criteria.
If you oughta use arrays, see the MIN + FILTER option below.
Theincludeargument is a simple expression:
This is an example of usingBoolean logicin Excel.
In the second array, TRUE values indicate values above a temperature of 72. you’re free to instead provide anarrayof values created with another operation.
This is important when source data needs to be manipulated before a minimum value is calculated.
Working from the inside out, theIF functionis evaluated first.
Only values associated with group “A” and a temperature greater than 72 make it through the filter.
The other values are replaced with FALSE.
The MIN function ignores empty cells, the logical values TRUE and FALSE, and text values.
More than one condition can be tested by nesting IF functions.
