Smallest number > 0

I have a colum of numbers that equal a sum of 3 cells in that line that have not been input yet, i.e.,

A B C D(=sumA+B+C)
1 3 4 5 12
2 4 6 8 18
3 5 10 15 30
[
[
[
[
36


High =Max(colum d) or 30
Low = Need to read 12, but reference all the way down to d-36, just ignore the 0 values and give the smallest value over 0.

I need the max number for colum D(which I all ready have) and the mina number for colum d, however because I have not filled in lines 3 thru 36, I get zero. Is there any way to pull the smallest number or mina >0. I have corrected all the other formulas on this and this last one is killing me because I know there is a way, but can't seam to get it. And I am a self taught novice at best.

Thanks in advance

Hi,

Try this

=MIN(IF(D1:D36>0,D1:D36)) enter as an array with Ctrl+Shift+Enter

An alternative non-array:

=SMALL(D1:D36,COUNTIF(D1:D36,"<=0")+1)