Hello,
On my table I have at the end SUM of the above rows, but now I would like to do an average of the days that have more than a Zero value in them.
The first pic below is the average result when I average the cells I want, the send picture is my terrible effort at getting the desired result. Results in a Failure....
Thank you
MacBook Air (2018 or later)
Instead of "<>01" use one of the following:
">0m"
">"&DURATION(0)
"<>0m"
"<>"&DURATION(0)
">0m" and ">"&DURATION(0) best fit your description of "have more than a zero value in them".
">"&DURATION(0) is probably the more robust of the two because it is definitely a duration value, the other is more of a shorthand way to do it.
Instead of "<>01" use one of the following:
">0m"
">"&DURATION(0)
"<>0m"
"<>"&DURATION(0)
">0m" and ">"&DURATION(0) best fit your description of "have more than a zero value in them".
">"&DURATION(0) is probably the more robust of the two because it is definitely a duration value, the other is more of a shorthand way to do it.
Perfect thanks
Averaging Time
