1. For example, the SUMPRODUCT function below calculates the total amount spent.
2. The ranges must have the same dimensions or Excel will display the #VALUE! error.
How to calculate the sum Product in MS Excel
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.
12
Sep
2014
1. For example, the SUMPRODUCT function below calculates the total amount spent.
2. The ranges must have the same dimensions or Excel will display the #VALUE! error.
0 comments:
Post a Comment
Click to see the code!
To insert emoticon you must added at least one space before the code.