Weighted Calculation

Learn how SUMPRODUCT multiplies aligned ranges and sums the results, when it raises an error, and how text in a range can silently change the total.