# Excel SUMPRODUCT Function

Home ➜ Excel Functions List (Top 100) Examples + Sample File ➜ **Excel 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.

**Hey Listen,**

This Microsoft Excel Guide will help you to learn some of the basics, and here you can find 100 Quick Excel Tips to get into the next level.

## Related functions

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

**About the Author**

**Puneet Gogia**

Puneet is using Excel since his college days. He helped thousands of people to understand the power of the spreadsheets and learn Microsoft Excel. You can ﬁnd him online, tweeting about Excel, on a running track, or sometimes hiking up a mountain.

COPYRIGHT © 2020 • EXCEL CHAMPS