Take the 2-minute tour ×
Super User is a question and answer site for computer enthusiasts and power users. It's 100% free, no registration required.

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?

share|improve this question
add comment

2 Answers

up vote 2 down vote accepted

Libreoffice calc has the sumproduct() function. If you name the ranges of the grade and cp columns (as described here), you can simplify the formula to =sumproduct(grade,cp)/sum(cp).

share|improve this answer
add comment

The easiest way would be to add an extra (hidden) column with the product and sum that column.

share|improve this answer
add comment

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.