Min If???
rmeister schreef:
I am trying to return the Min of 1 column if the criteria I specify
matches.
For Example, I want this to work like a SUMIF. If A:A is equal to CELL
C2 then return the minimum of column B:B.
Is this Possible???
You almost gave the answer yourself: =IF(SUM(A:A)=C2;MIN(B:B);value if
not true)
|