Weighted Average

[Joe Mac]

Does anyone know of the existence of a "weighted average"
Excel function?

 

[Bernie Deitrick]

Joe,

Use

=SumProduct(values range, weight range)/Sum(weight range)

HTH,
Bernie
MS Excel MVP

 

[Peo Sjoblom]

SUMPRODUCT(score,weights)/SUM(weights)

 

[Leo Heuser]

Joe Mac

It doesn't exist. You have to roll your own.
Come back with an example, if you need further help.