I've used this function successfully to calculate the number of business days
between two dates. For rows in which there are no data, the value of "0"
comes up by default. (This is a simple list in which a person enters data - I
don't want to use data forms.)

With these data, I want to calculate MIN, MAX and AVG values.

How do I go about doing this while discounting the default zeros? This skews
my data considerably!

Thanks to all for any response.

=MIN(IF(Range<0,Range))

entered with ctrl + shift & enter


Regards,

Peo Sjoblom

"Allen7575" wrote:

I've used this function successfully to calculate the number of business days
between two dates. For rows in which there are no data, the value of "0"
comes up by default. (This is a simple list in which a person enters data - I
don't want to use data forms.)

With these data, I want to calculate MIN, MAX and AVG values.

How do I go about doing this while discounting the default zeros? This skews
my data considerably!

Thanks to all for any response.