Hi,
I have a workbook with a bunch of grades and a bunch of graders.
I have 120 students who each wrote a paper and each paper was graded by 3
editors but not all editors read all papers.
To make the results fair, I want to use the average and stddev of each
grader's grades and apply it to create an "adjusted score" for each grade.
Currently, the data is arranged such that it is:

Student Editor Name1 Score Editor Name2 Score Editor Name3
Score
A John 20 Jane 25
Joe 22
B Betsy 21 John 29
Bob 23

And so on for a total of 122 students.

I know how to do a countifs to find the number of grades each editor entered
but I'm totally struggling to figure out a way to calculate the mean and
standard deviation of all the grades for each editor.

Any ideas?