Weighted Average

  • Thread starter Thread starter Joe Mac
  • Start date Start date
J

Joe Mac

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

Use

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

HTH,
Bernie
MS Excel MVP
 
Joe Mac

It doesn't exist. You have to roll your own.
Come back with an example, if you need further help.
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Weighted Averages 7
weighted average - 1 column 2
Weighted Average Calc for duplicated values only 0
Help With Formula For Cell Addresses 2
weighted average from table 3
How do I calculate a weighted average and exclude the empthy cells 2
Weighted grades 2
Calculate weighted average for 1 column 3

Back
Top