suming column values based on condition and store it in variable MVC4?

I have enrollment_ms table in which fields are studentID, SUbjectID, GPA i want to calculate cummulative CPGA by adding the GPA column values where sutdent id is same and display it on view !! CGPA=suming of GPA of every subject there and divided by no. of subjects!!