My company uses a spreadsheet to compile employee's scores from training quizzes. I need to figure out a way to be able to add all of the employee's scores up and then divide them by the total possible points to provide a percentage based-score of the all the quizzes. I also need to use a formula to create an average quiz score for each employee.
The problem is that the spreadsheet is setup so that if an employee has not taken a quiz yet, instead of the score, the respective cell says #NA. There are also other employees who created quizzes and their cells in those cases say TestMaster. There are also blank cells that need to be disregarded in the formula too. I need to figure out how to setup the SUMIF equation to disregard the #NA and TestMaster input. And then, if it isn't to complicated, I'd like to remove those scores from the overall score so they are not negatively impacted for not having taken a quiz yet. If that is too complicated, then I will settle for replacing the #NA for a score of zero and the TestMaster for a score of ten. Similarly, the Average Quiz Score needs to reflect only the quizzes that have been taken. And same substitutes for the #NA and TestMaster as above. I've attached a screen shot of the spreadsheet. It uses an example email address so all of the score fields just say #NA but hopefully it will help you visualize the issue. -- You received this message because you are subscribed to the Google Groups "Google Spreadsheets API" group. To unsubscribe from this group and stop receiving emails from it, send an email to [email protected]. For more options, visit https://groups.google.com/groups/opt_out.
<<attachment: spreadsheetScreenshot.PNG>>
