Weighted Average Calculation

  • Thread starter Joseph M. Yonek
  • Start date
J

Joseph M. Yonek

I have two tables that have the row labels that are in different orders. I
need to calculate the weighted average of the comparative information in
each of these tables. If they were in the same order I would use sumproduct
and divide by the total.

Unfortunately, the tables have to remain in separate orders and values in
matching rows have to be matched to calculate the weighted average.

Any suggestions?

Thank you in advance for any insights.

Joe
 
L

Lance

If I understand you, you want to do a conditional
sumproduct and do a weighted average. This example shows
a the weighted average of the sale of "peas". If the
label catagory is not "peas", zero is multiplied by the
data in the columns.

=SUMPRODUCT((A2:A6="peas")*B2:B6*C2:C6)/SUM(C2:C6)

You might also do a google search using
weighted average group:*Excel*
 

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 % Complete calculation 1
Weighted Averages 7
How do I calculate a weighted average and exclude the empthy cells 2
weighted average - 1 column 2
Finding the weighted average of text that have been given values 1
Excel formula help for calculating freight. 2
Calculate weighted average for 1 column 3
Weighted ranking of a series 3

Top