Minimum formula the excludes zeros

My column contains formulars that total weekly share prices, this shows zeros
because that weeks prices are still to be entered, or the week is a future
week.
I require a fomular that shows the minimum total, excluding the zeros.

current formula =min(a5:a35)

Thanks for any help
Joco

> current formula =min(a5:a35)

Try something like:
=MIN(IF(A5:A35>0,A5:A35))
Array-enter the formula by pressing CTRL+SHIFT+ENTER
(instead of just pressing ENTER)
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---
"Joco" wrote:
> My column contains formulars that total weekly share prices, this shows zeros
> because that weeks prices are still to be entered, or the week is a future
> week.
> I require a fomular that shows the minimum total, excluding the zeros.
>
> current formula =min(a5:a35)
>
> Thanks for any help
> Joco

Max thanks formula works great.
Would quite like to be in Singapore right now, weather in London is not good
thanks again Joco

"Max" wrote:

> > current formula =min(a5:a35)
>
> Try something like:
> =MIN(IF(A5:A35>0,A5:A35))
> Array-enter the formula by pressing CTRL+SHIFT+ENTER
> (instead of just pressing ENTER)
> --
> Max
> Singapore
> http://savefile.com/projects/236895
> xdemechanik
> ---
> "Joco" wrote:
> > My column contains formulars that total weekly share prices, this shows zeros
> > because that weeks prices are still to be entered, or the week is a future
> > week.
> > I require a fomular that shows the minimum total, excluding the zeros.
> >
> > current formula =min(a5:a35)
> >
> > Thanks for any help
> > Joco

Good to hear that !
Hope I've sent some Singapore "sunshine" to you over there <g>
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---
"Joco" wrote:
> Max thanks formula works great.
> Would quite like to be in Singapore right now, weather in London is not good
> thanks again Joco