Thread: Min If
View Single Post
  #6   Report Post  
Posted to microsoft.public.excel.programming
Otto Moehrbach Otto Moehrbach is offline
external usenet poster
 
Posts: 1,090
Default Min If

Perhaps something like:
If(your criteria, Min(A1:P100),"No")
HTH Otto
"Aaron" wrote in message
...
I am looking for a function that is a lot like SUMIF function but is Min
if.
Returns the min in a range by criteria.
Range, Criteria, and Min range
Any help would be great.
Thanks in advance!

Aaron