I am using a MIN function to determine my lowest Subcontractor Bid. =MIN(R86,U86,Z86,AC86,AF86,AI86) I have six columns for 6 subs. Herein lies the problem. I only have three subs bidding so the MIN is picking up the first zero columns as Low Sub with zero dollars. Is there a way to do this without revising the MIN function to take out the three cells I do not need.