Hi Everyone,
This is my first post. I have been using the posts I read here for help frequently. Now I’m unsure of how to write this more effectively and efficiently. This is for a Accumulated Grade Point Average on a transcript. Each semester has to be added to the equation from the earlier equation. As you can see, they get messy quick. Any suggestions?

Year Semester 1 Equation

Year 1 Semester 1 [=SUMPRODUCT(J10:J16,I10:I16)/SUM(I10:I16)] J10:J16 arethe point values for each grade. I10:I16 are the credits earned for each grade.

J10:J16
Year 1 Semester 2 [=(SUMPRODUCT(J10:J16,I10:I16)+SUMPRODUCT(T10:T16,S10:S16))/(SUM(I10:I16)+SUM(S10:S16))]

Year 2 Semester 1 [=SUMPRODUCT(J10:J16,I10:I16)+SUMPRODUCT(T10:T16,S10:S16)+SUMPRODUCT(J23:J29,I23:I29))/(SUM(I10:I16)+SUM(S10:S16)+SUM(I10:I16))]

Year 2 Semester 2 By now its to messy for me to type it accurately enough to have it work. By the end of the Senior year I will be in a real mess. Is there anyway to simplify this process?