I am trying to create a quality index to rate article submitted. I have the standard weighted sum formula currently in use, but the problem is an article can have multiple problems so the number of articles reviewed is not necessarily the number of problems found.
The worksheet should show 100% if no issues have been found. If someone has 5 things wrong and 2 articles submitted they shoudl have a lower score then someone with 10 things wrong but 10 articles submitted.
If more clarification is needed please let me know. I have attached an example sheet for reference.
Once everything works out I will put my final, completed worksheet for others to use.
Bookmarks