# MIN Function Calculations

#### abacon1960

##### Board Regular
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>

### Excel Facts

Create a Pivot Table on a Map
If your data has zip codes, postal codes, or city names, select the data and use Insert, 3D Map. (Found to right of chart icons).
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
RSTUVWXY
4Sub1Sub2Sub3Sub4Sub5Sub6Min
5010,00012,10010,8000010000
Sheet1

Maybe

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

Replies
3
Views
267
Replies
1
Views
446
Replies
3
Views
425
Replies
0
Views
576
Replies
8
Views
2K

### Forum statistics

1,221,053
Messages
6,157,640
Members
451,426
Latest member
VinnyDoesntKnowExcelCode

### We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.

### Which adblocker are you using?

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

### Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

### Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back