Loading…
Loading…
SUMPRODUCT multiplies matching items in ranges and adds the results. Multiply by a condition like (B2:B5>=5) to include only some rows.
Syntax
SUMPRODUCT(array1, [array2], …)
Read the lesson, then try it yourself in a live spreadsheet.