FG

Calculate sum of products in LibreOffice Calc

Fresh3 days ago
Mar 15, 202610171 views
Confidence Score0%
0%

Problem

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. 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 cr…

Error Output

study  grade  cp
a      2.3    8
b      2.0    6
c      1.7    6

Unverified for your environment

Select your OS to check compatibility.

1 Fix

Canonical Fix
Unverified Fix
New Fix – Awaiting Verification

Fix for: Calculate sum of products in LibreOffice Calc

Low Risk

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 .

Awaiting Verification

Be the first to verify this fix

Sign in to verify this fix

Environment