Averaging scores with certain criteria
I would like to get averages of scores of applications sent in considering certain criteria.
There are applications that are submitted, and each application is scored by 5 people.
You can see these applications are named Q3-03, Q3-04 etc....
Sometimes the scorers recuse themselves from scoring and their score appears as zero, but they just refuse to score that particular application, and their zero shouldn't be counted in the average.
Sometimes not all the scorers have submitted their scores at the time, but whoever has turned in a score I would like to be included in the average.
I'm new to functions and been trying to figure this one out and having a hard time. I'm hoping I can get some help. Thank you!
Answers
-
Use a SUMIF/COUNTIFS
Example
=(Sumif([Application ID/Name/Category]:[Application ID/Name/Category],Q3-03))/(COUNTIFS([Application ID/Name/Category]:[Application ID/Name/Category],Q3-03,[Score]:[Score],>0)))
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Customer Resources
- 64.9K Get Help
- 441 Global Discussions
- 139 Industry Talk
- 472 Announcements
- 4.9K Ideas & Feature Requests
- 129 Brandfolder
- 148 Just for fun
- 68 Community Job Board
- 496 Show & Tell
- 33 Member Spotlight
- 2 SmartStories
- 300 Events
- 36 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!