Min(IF(#>0)) Help

[Legacy 327601]

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.

 

[Scott Huish]

Perhaps:

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

Confirm with CTRL-SHIFT-ENTER

 

[Legacy 327601]

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!

 

[Scott Huish]

The MIN of what range?

 

[Legacy 327601]

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

 

[Scott Huish]

=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

 

[Legacy 327601]

Thank you, Scott. This works.