Average values weighted by quantity, score, or any weight column.
Copy this formula
=SUMPRODUCT(B2:B10, C2:C10)/SUM(C2:C10)SUMPRODUCT multiplies each value by its weight and sums the results; dividing by the total weight gives the weighted average. It's the standard way to average grades, prices, or ratings by volume.
=SUMPRODUCT(Price, Qty)/SUM(Qty)→12.40Average price weighted by quantity sold.
AVERAGE treats every row equally. A weighted average lets larger quantities count more, which is usually what you want for prices or grades.
Need a formula for your own data?
Describe what you want in plain language and let ExcelGPT write, explain, and verify the formula — free to start, no plugin.