Home |
Search |
Today's Posts |
|
#1
|
|||
|
|||
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. |
#2
|
|||
|
|||
=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. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Need a ISWorkday Function -- Any Ideas | Excel Worksheet Functions | |||
How do I install the networkdays function! | Excel Worksheet Functions | |||
Calculating days between current date and a date in future NETWORKDAYS() function | Excel Worksheet Functions | |||
Nested IF Function, Date Comparing, and NetworkDays Function | Excel Worksheet Functions | |||
MS Excel Function - Networkdays | Excel Worksheet Functions |