# Excel SUMPRODUCT Function

HomeExcel FunctionsExcel SUMPRODUCT Function (Example + Sample File)

## What is EXCEL SUMPRODUCT FUNCTION

The Excel SUMPRODUCT Function is listed under Microsoft Excel's Maths Functions category. It returns a value after sum and multiplies values from the ranges or arrays. In simple words, it first multiplies the corresponding cells from ranges and then sums up all the values.

## How to use it

To learn how to use the SUMPRODUCT function in Excel, you need to understand its syntax and arguments:

### Syntax

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

### Arguments

• array1: The first array you want to multiply and then add.
• [array2]: The second array you want to multiply and then add.

### Notes

• If skip you to specify array2, SUMPRODUCT will simply sum the array1.
• The maximum size of each array should be the same. If array1 has 5 cells then cells in array2 should be 5.
• Text and other non-numeric entries will be treated as 0.

## Example

To master the SUMPRODUCT function we need to try it out in an example and below is one which you can try out:

In the below example, we have used SUMPRODUCT to multiply and sum up the values from column D and column F. First, it has multiplied the values from column D with column F and then sums up the values.

## Related functions

This tutorial is the part of our Excel Functions with Examples (Function Guide) and below are some of the related functions: 