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...
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.
