Spreadsheets: Google Sheets: sumproduct
Self-tutoring about spreadsheet use: the tutor mentions sumproduct in Google Sheets.
The following is by my understanding.
Let’s imagine you want the sum of squares of the numbers 1 through 10. On Google Sheets, that’s easy to accomplish using sumproduct.
Step 1: enter the numbers 1 through 10. For generality, imagine they are in cells b12 through b21.
Step 2: in a different cell, let’s imagine d8, key in =sumproduct(b12:b21,b12:b21).
Step 3: hopefully in d8 the answer, 385, will now appear.
Google Sheets sumproduct multiplies the corresponding members of two lists, then adds up all those products to arrive at the result.
Source:
Jack of Oracle Tutoring by Jack and Diane, Campbell River, BC.