Weighted Average Calculation

  • Thread starter Thread starter Joseph M. Yonek
  • Start date 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
 
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*
 
Back
Top