Min

[Peo Sjoblom]

Change the MIN part to

MIN(IF(B5:B450<>0,B5:B450))

you need to enter any formula with this with

ctrl + shift & enter

--

Regards,

Peo Sjoblom

(No private emails please, for everyone's
benefit keep the discussion in the newsgroup/forum)

 

[DNF Karran]

How about

=MIN(IF(C2:C8<>0,C2:C8,""))

This will convert the zero's to zero length text strings so ignore the
from the MIN() function

 

[David North]

I am trying to display a min value from a column of data that refer to
various other sheets.

Whilst the formula =IF(SUM(B5:B45),MIN(B5:B450,"") works ok, I want it to
ignore zero data. Although I can achieve this with numerical data, it does
not appear to work with formula's.

Any ideas would be welcome.

David