I am not that proficient in using Excel/Calc and I have a simple question.
I have a table of my studies, my grades and the respective credit points on those.
study grade cp a 2.3 8 b 2.0 6 c 1.7 6
Something like the above. What I want to do now is to multiply each line and add the products, afterwards divide by the sum of the overall credit points, to get the effective grade for each semester.
My formula is:
(grade1 * cp1 + grade2 * cp2 + grade3 * cp3) / (sum(cp1:cp3))
Is there any way to shorten the insides of the first bracket to something like a vectorized operation or so, which would make it easier to use it with other semesters as well without retyping all the stuff?