Thread: Min If???
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Bart Snel
 
Posts: n/a
Default 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)