finding a minimum

D

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
 
R

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Second Smallest Number in a Set 8
Finding Smallest Date in Non Contiguous Range 3
finding minimum value 2
Finding the minimum value in a list but excluding zeros - a variationon an old problem 10
Conditional Minimum value 2
Min If 6
Looking for a way to calculate the minimum and maximum value of a formula . 0
Min Max function 2

Top