Using AVG to Calculate Average Completion Time
Good afternoon,
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 :)
Best Answer
-
If you add an iferror statement to your column formula in Completion Time you can get rid of that error message.
Add this to the front of your formula: =iferror(
Then add this to the back: ,"")
If you copy and paste your formula I can show you better.
Answers
-
If you add an iferror statement to your column formula in Completion Time you can get rid of that error message.
Add this to the front of your formula: =iferror(
Then add this to the back: ,"")
If you copy and paste your formula I can show you better.
-
Thank you so much, that solved my problem!
Help Article Resources
Categories
Check out the Formula Handbook template!