Use SUMPRODUCT to Calculate Weighted Averages

There are some situations where Excel's AVERAGE function doesn't work. For those situations, you'll need to find the weighted average using the SUMPRODUCT function.

URL: http://blog.gcflearnfree.org/2013/10/10/use-sumproduct-to-calculate-weighted-averages/