Calculating Min value excluding zeroes?

  • Thread starter Thread starter Carol B
  • Start date Start date
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
 
Hi Carol

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

HTH
Frank
 
Back
Top