Forum Discussion
Match / CountIfs or other?
Is anyone able to help me with a formula that I have been struggling with for some time now. I would like to calculate the value added score across the whole group of learners from their Projected Gr...
Since you've already rendered the names anonymous, could you go the next step toward helping us help you by posting not an image but the actual file. Put it on OneDrive or GoogleDrive with a link pasted here that grants access to it.
Thank you, I have attached it to the message above now.
See the attached version.
I defined a named range Grades on DataSheet and used that in the formulas.
- Thank you, that looks great and completely makes sense. Would there be a way to calculate the score as a total; for example a learner who has projected grade as P but the Minimum Expected grade should be HM that would be -2 points. Another student who has projected grade as M and Minimum Expected grade a HP this would be +1.
