AnsweredAssumed Answered

Calculating based on values across a row and based on a column.

Question asked by triplejs15 on Jan 26, 2016
Latest reply on Feb 29, 2016 by triplejs15

I have the following list in SharePoint and I would like to take the student selected in the second column find their score on the grid and get the teachers average in a new column named total column.

 

TeacherStudent SelectedStudent 1Student Grade 1Student 2Student Grade 2Student 3Student Grade 3Total
85John DoeJane J56John Doe90Bruce Wayne69

Outcomes