# Min(IF(#>0)) Help

L

#### Legacy 327601

##### Guest
Hi All,

I have a column of numbers. Some rows are 0. I want to get the min of this column excluding the 0's. So far my formula is:

{MIN(IF(\$A\$76:\$A\$341=A8,\$H\$76:\$H\$341))}

Column H is the column that contains 0

Column A contains unit types.

Thank you for your help.

### Excel Facts

Difference between two dates
Secret function! Use =DATEDIF(A2,B2,"Y")&" years"&=DATEDIF(A2,B2,"YM")&" months"&=DATEDIF(A2,B2,"MD")&" days"
Perhaps:

=MIN(IF(\$A\$76:\$A\$341=A8,IF(\$H\$76:\$H\$341<>0,\$H\$76:\$H\$341)))

Confirm with CTRL-SHIFT-ENTER

Perhaps:

=MIN(IF(\$A\$76:\$A\$341=A8,IF(\$H\$76:\$H\$341<>0,\$H\$76:\$H\$341)))

Confirm with CTRL-SHIFT-ENTER

Scott,

Thank you this works.

Now I am trying to find the min assuming the lease was signed past a certain date. This is what I have added onto your formula(highlighted in bold):

=+MIN(IF(\$A\$76:\$A\$341=\$A42,IF(\$H\$76:\$H\$341<>0,\$H\$76:\$H\$341,AND(\$I\$76:\$I\$341,">="&\$AA\$6,\$I\$76:\$I\$341))))

Column I are dates. AA6 is the date that column I must be greater than or equal to.

Thanks again!

The MIN of what range?

The MIN of column H assuming the corresponding date is greater than AA6.

=MIN(IF(\$A\$76:\$A\$341=\$A42,IF(\$H\$76:\$H\$341<>0,IF(\$I\$76:\$I\$341>=\$AA\$6,\$H\$76:\$H\$341))))

Confirm with CTRL-SHIFT-ENTER

Thank you, Scott. This works.

Replies
5
Views
258
Replies
8
Views
225
Replies
8
Views
163
Replies
5
Views
175
Replies
1
Views
78

1,203,060
Messages
6,053,303
Members
444,650
Latest member
bookendinSA

### 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.
Allow Ads at MrExcel

### Which adblocker are you using?

Follow these easy steps to disable AdBlock

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

### Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

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