SMALL function

Good Morning Eveyrone,
Using Excel XP. I would I write the formula =SMALL(A1:A100) that would find
the lowest numbers that are NOT zeros.
Thanks for you help,
Mike

=SMALL(A1:A100£¬1)

SMALL(A1:A100,COUNTIF(A1:A100,"<=0")+1)

Thanks...got it working..
Mike
"ΊΌΦέΘΛ" <cncola@hotmail.com> wrote in message
news:OwrqY9NRFHA.3288@TK2MSFTNGP14.phx.gbl...
> SMALL(A1:A100,COUNTIF(A1:A100,"<=0")+1)
>
>