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
- Customer Resources
- 64.8K Get Help
- 434 Global Discussions
- 138 Industry Talk
- 470 Announcements
- 4.9K Ideas & Feature Requests
- 129 Brandfolder
- 148 Just for fun
- 65 Community Job Board
- 486 Show & Tell
- 33 Member Spotlight
- 2 SmartStories
- 300 Events
- 36 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!