Calculating Min value excluding zeroes?

C

Carol B

Is there a way to calculate the minimum value of a group
of cells, but to ignore any zero (0) values in the
minimum calculation? For example, if the individual cell
values are 0,3,12,0,2, I want the expression to return a
value of "2". Thanks! ~Carol
 
F

Frank Kabel

Hi Carol

one way: enter the following as array formula (CTRL+SHIFT+ENTER)
=MIN(IF(your_range>0,your_range,""))

HTH
Frank
 

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

Min Function 8
Divide by the minimum non-zero number in a range of cells 21
Using Min Formula with Multiple Criteria Excluding Zeros 5
Finding Min Cell values excluding zero in alternate columns 9
Min excluding zero values, without an array fomrula 13
Minimum without zeros or negatives 3
Omitting zeroes when looking for minimum values 2
Trying to find additional ranges outside of min, max, and average 2

Top