What is the formula for weighted average (mean) in Excel? | Excel Help HQ - Helping you Solve Excel

=sumproduct([values],[weights])/sum([weights]) A weighted average (mean) is similar to the arithmetic average (mean), except values to be average are given different weight or emphasis. As seen in the example below, the weighted average is much lower than

excelhelphq.com