min conditional statement

[Maria L]

I am trying to find a the smallest number that is greater
than 0. I used the following:

=MIN(IF(B5:W5>0, B5:W5))

But I am getting an error #VALUE!

What am I doing wrong

 

[Dan E]

Maria,

That will work if you array enter it.
(control + shift + enter)
if you do it right { } will appear around your formula.

If you don't want to use array formula's

=SMALL(A6:A13,COUNTIF(A6:A13,">0")+1)

Dan E

 

[Dan E]

Mistake! That second formula should read

=SMALL(B5:W5,COUNTIF(B5:W5,"<=0")+1)

Dan E