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
- All Categories
- 14 Welcome to the Community
- Customer Resources
- 67.8K Get Help
- 474 Global Discussions
- 205 Use Cases
- 516 Announcements
- 5.5K Ideas & Feature Requests
- 87 Brandfolder
- 157 Just for fun
- 82 Community Job Board
- 521 Show & Tell
- 36 Member Spotlight
- 3 SmartStories
- 309 Events
- 37 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!