MINIF Function

[BHomestar]

Hey All!

In the below formula I am trying to return the minimum value in column AH that has the criteria of B37 in column G. The formula is not properly finding the values in column G that meet criteria B37. Could someone help me to fix this?

=--(INDEX(Pricer!G:G,C$4):INDEX(Pricer!G:G,D$4)=B37)--MIN(INDEX(Loans!AH:AH,C$4):INDEX(Loans!AH:AH,D$4))

Thanks!!

Bryan H.

 

[Aladin Akyurek]

Thanks Aladin for the quick reply. That worked perfectly!

You are welcome.