Using AVG to Calculate Average Completion Time
I am trying to find the average of a column and am having problems using AVG, AVG COLLECT, etc.
I am trying to find the average of "Completion Time" column.
As you can see sometimes there is no data and sometimes it says "invalid data" while awaiting the completion date. I want to put an average completion time field in my sheet summary.
Can someone help me? Thanks! @Paul Newcome maybe you can help :)
Help Article Resources
Check out the Formula Handbook template!