Weighted Sum Product - Logic

[cardlife]

Hi All,

I'm trying to find the Weighted Avg for 2 products.


Basically, Each product - has multiple Stock Numbers.

I have a Units_Sold/Per_Wk/Per_Store calculation for each Stock Number.


What I would like to find is what is the Units_Sold/Per_Wk/Per_Store for each product.


Here is the example file. I have done a sumproduct but I'm not sure if the logic makes sense.

Please give me any suggesions on how to improve this or if there is a better way of finding this numbber. Thank you so much!


https://rapidshare.com/files/2634981516/Reqst1.xlsx

 

[Hui]

Cardlife


Firstly, Welcome to the Chandoo.org Forums


Your formula is correct


I would structure it slightly differently as:

=SUMPRODUCT(($C$14:$C$44=H6)*$H$14:$H$44*$E$14:$E$44)/SUMIF($C$14:$C$44,H6,$E$14:$E$44)

But its effectively the same as yours

 

[cardlife]

Thank You!!