Function "Networkdays"
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. |
All times are GMT +1. The time now is 08:35 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com