finding a minimum

[David Netser]

how can i find a the smallest number in a row (min function), provided that
its not zero. i am looking for something which is equivalent to sumif.
thanks, david

 

[Rick Rothstein]

You can use this array-entered** formula to do that...

=MIN(IF(A2:J2>0,A2:J2,""))

**commit this formula using Ctrl+Shift+Enter, not just Enter by itself

 

[David Netser]

Rick, many thanks it works perfectly, rgds, david