# 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.

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.

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