Hey, Im not sure if this is the right place to post this, but I need some help.

I have 14 classes of 40 students each and I need to make a grade book with excel.

Here's what I need help with:

I'm adding grades to column G, in column H I've entered the value of 2. I need to add 2 points to each grade from column G so that G+H=I. Then, I need to find the average for each student. Is there a way to do this with out having to type "=sum(g3,h3), =sum(g4,h4), =AVERAGE(G2,I2) etc..." individually?

I realize the example I posted is easy math and I can quickly add that in my head. For some classes its not as easy and there are lots of students to do this for. I want to just plug grades in for each class and come up with averages quickly.