Sumproduct

 

To calculate the sum of the products of corresponding numbers in one or more ranges, use Excel's powerful SUMPRODUCT function.

1. For example, the SUMPRODUCT function below calculates the total amount spent.

Sumproduct Function in Excel

Advertisement

Note: the SUMPRODUCT function performs this calculation: (2 * 1000) + (4 * 250) + (4 * 100) + (2 * 50) = 3500.

2. The ranges must have the same dimensions or Excel will display the #VALUE! error.

Ranges of Unequal Size

3. The SUMPRODUCT function treats any entries that are not numeric as if they were zeros.

Non Numeric Entries

Advertisement

Please show your appreciation by sharing this page

Go back to count and sum functions, Go to the right >>
Go to Top: Sumproduct    |    Go to Next Example: Nested If