MIN Function Calculations

[abacon1960]

I am still having problems with the MIN function. I have 6 cells that add up separate Subcontractor Bids. I do not always get 6 bids so some of them are left at zero. In other words, the MIN function gives me back a Zero ($0) dollar amount as the apparent low bidder and does not account for the three (3) bids I do have. Is there a way to make this work without altering my formula? =MIN(R5,S5,T5,U5,V5,W5) I want the MIN to ignore the $0 cells and acknowledge Sub2 as the low bidder.

Sub1	Sub2	Sub3	Sub4	Sub5	Sub6
$0	$10,000	$12,100	$10,800	$0	$0

<tbody>
</tbody>

 

[FormR]

Is there a way to make this work without altering my formula?

No, you will need to use a different formula, for example (note the Array instructions beneath the formula)

Excel Workbook
	R	S	T	U	V	W	X	Y
4	Sub1	Sub2	Sub3	Sub4	Sub5	Sub6		Min
5	0	10,000	12,100	10,800	0	0		10000
Sheet1

 

[Special-K99]

Maybe

=MIN(IF(R5:W5>0,R5:W5))