SUMPRODUCT

The purpose of the SUMPRODUCT function is to multiply, then sum, arrays. If only one array is supplied, SUMPRODUCT will simply sum the items in the array. Up to 30 arrays can be supplied.

SUMPRODUCT
=SUMPRODUCT (array1, [array2], …)

array1: The first array or range to multiply, then add.

array2: [optional] The second array or range to multiply, then add.

One clap, two clap, three clap, forty?

By clapping more or less, you can signal to us which stories really stand out.