Try...

=MIN(IF(INDEX(4:4,3):H40,INDEX(4:4,3):H4))

....confirmed with CONTROL+SHIFT+ENTER.

Hope this helps!

In article ,
"Andy" wrote:

I am currently using C through H to find the find the smallest value by using
the following formula
{=min(if((C4:H4)0,(C4:H4))}

But now i want to have automatically find the smallest value if i inserted a
new column. So i used this formula

{=min(if(Indirect("C"&Row()&":"&address(Row(),Colu mn()-1))0,Indirect("C"&Row(
)&":"&address(Row(),Column()-1)))}

But its not working i am getting a #value error.

So what is wrong, i dont see it