Average calculation from overall ratings
Hi All, I'm trying to calculate average of these rating in Average column excluding "NA",
for example if "NA" is applied in any column the formula should exclude that column and calculate for the remaining columns.
Please help me with the formula.
Best Answer
-
Hi @Domnic Victor ,
This formula should do it for you:
=AVG([Domain Knowledge]@row:[Overall rating of the engagement]@row)
The NAs will already be excluded in the average:
One caveat: from your screenshot it looks like there are possibly some hidden columns between "Timely Delivery" and "Alignment..." so I would suggest moving these to one side or the other of the columns you're trying to average so they are not included.
Hope this helps - any questions etc. then just post! 😊
Answers
-
Hi @Domnic Victor ,
This formula should do it for you:
=AVG([Domain Knowledge]@row:[Overall rating of the engagement]@row)
The NAs will already be excluded in the average:
One caveat: from your screenshot it looks like there are possibly some hidden columns between "Timely Delivery" and "Alignment..." so I would suggest moving these to one side or the other of the columns you're trying to average so they are not included.
Hope this helps - any questions etc. then just post! 😊
-
its working! Thank you so much, you made it very simple.
-
No problem, glad to be of assistance!
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Smartsheet Customer Resources
- 62.8K Get Help
- 376 Global Discussions
- 207 Industry Talk
- 440 Announcements
- 4.5K Ideas & Feature Requests
- 139 Brandfolder
- 129 Just for fun
- 130 Community Job Board
- 449 Show & Tell
- 30 Member Spotlight
- 1 SmartStories
- 284 Events
- 33 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!