Formula to display minimum positive and non-error value

[FinanceFD]

I've got a range from I9:I16 that I need the minimum positive value for. The problem for a =MIN array formula is that at times there may be a #VALUE error in these cells. Within these cells there are formulas that have changing numbers based on inputs from a separate part of the excel sheet.

Thoughts? Thanks in advance.

 

[Michael M]

Why do they have a #VALUE error.
It might be easier to simply, fix the offending formula causing the VALUE error
Can you post that formula, and give us an example of when it #VALUEs

 

[Asala42]

Try: {=MIN(IF(ISERROR($A$2:$A$100)=FALSE,IF($A$2:$A$100>0,$A$2:$A$100)))}

array formula: hit Ctrl+Shift+Enter to get the brackets.