This online culinary weight and mass measures converter, from mg into kg units, is a handy tool not only for experienced certified professionals in food businesses and skilled chefs in state of the industry's kitchens model.
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.
We can use the SUMPRODUCT function to multiply each score by its weight and then sum those products. This gives us a result of 81.43. This can be simplified if the sum of the weights in 1. For example, if we use as weights percentages, the weights in the example above become 14%, 14%, 29%, and 43%. This works because the sum of the weights is 1, so we are just eliminating the unnecessary division by 1. This page last updated: 28-Oct-2008.