SUMPRODUCT practice

SUMPRODUCT multiplies matching values in two or more ranges and adds the results. Below are the 3 Google Sheets exercises on Sheetsdrill that use it, each checked instantly in your browser.

Syntax

SUMPRODUCT(array1, [array2], ...)

What people get wrong

Price times quantity for a whole order in one formula, and a weighted average when divided by the total weight.

Google Sheets exercises that use SUMPRODUCT

• Weighted average scoreLevel 2Pro
• Revenue above a minimum quantityLevel 4Pro
• Orders placed at the weekendLevel 5Pro

Often used together with: SUM, WEEKDAY