SUMPRODUCT function. Add and multiply together.(Microsoft Excel)


Japanese version.

Add and multiply together.

How it works

=SUMPRODUCT(array1 to 255)
array1 to 255Only 1 is required.Target value.

Example Result

The following formula multiplies the values in columns C, D, and E (subtracted from 1) by the each row and sums the results.


Without SUMPRODUCT, it is necessary to calculate a subtotal for each row and then sum the totals using a SUM function or similar.

With the SUMPRODUCT function, you can complete the process in a single cell and function without subtotals.

The advantage is that the sheet and formula are therefore simpler.

Example without SUMPRODUCT function.



Microsoft Excel Functions Math & Trig

Examples of Use

How to make the VLOOKUP function case sensitive.