How To Use SUMPRODUCT Function

Summary

The Excel SUMPRODUCT is a function that helps to calculate multiplies range of cells or arrays and it gives the sum of products.

Purpose

Return sum of the arrays

Syntax

=SUMPRODUCT (array1, [array2], …)

Example

In the above mentioned example we have explained how to calculate the total sum of the sales in “IN” state from the given set of data. Formula used in G6 is:

Arguments

Array – [Required]: first multiplies then adds the values of the given arrays
Array– [Optional]: second multiplies then adds the values of the given arrays
scroll to top