Using fx MIN without returning errors

I am trying to use the min function to return the lowest number in a range, but some of those cells are !Value# and there fore are returning that as the minimum, which is not useful to me.

For example, I have two cells with the following corresponding values: A1: 8 B1: #Value! Min function returns "#Value!".

Is it possible to add criteria to this function (i.e return minimum if values are integers)?

Any ideas would be helpful, thanks.

Great, thank you.

One thing, why do I have to use an array function here?