Sumproduct formula

Calculates the sum of the products of corresponding entries in two equal-sized arrays or ranges.

How to use?

SYNTAX: =SUMPRODUCT(array1, [array2, …])
array1 - The first array or range whose entries will be multiplied with corresponding entries in the second array or range.
array2… - [optional] repeatable - The second array or range whose entries will be multiplied with corresponding entries in the first array or range.delimiter - The character or string to place between each concatenated value.

PRACTICE SHEET

The above sheet is view only mode, please make a copy to practice.

Copy of Sumproduct

Make A Copy

Page updated

Google Sites

Report abuse