Add ignore zero to a formula?

Heya,

So I was given this CF formula yesterday, thanks to Glenn Kennedy , and I adapted it to one for MIN and one for MAX, but I need it to ignore 0 when looking for MAX and MIN:

Formula:

Please Login or Register  to view this content.

I tried adding this to the formula "<>0" but it doesn't work for some reason, and I have looked online but cant find the answer?
I currently struggle with formula formation, as I am very new to it...

Any ideas?

Thanks in advance

Try:

Formula:

Please Login or Register  to view this content.

Maybe

Formula:

Please Login or Register  to view this content.

normally it's only necessary to exclude zero when looking for a minimum, but adapt that for your maximum if necessary.