Hi,
Can someone help create a formula for weighted averages according to criteria?
I want to know what was the average price I bought a product at on today's date. The average price needs to be weighted against the quantity of product sold.
I have attached the excel and would greatly appreciate help!
Thanks,
Leopold2000
Try this formula in C2
=SUMPRODUCT((A4:A100=A2)+0,B4:B100,C4:C100)/SUMIF(A4:A100,A2,B4:B100)
Audere est facere
Doesn't seem to work - tried putting it into the excel and no luck.
Formula:
Please Login or Register to view this content.
Same as Daddylongleg formula.
Your attachment cell format is set as date. It is why you get ##### value. I changed it to number format. See attachment.
Click * to reward me...
Thank you...
how to determine 'Weighted Average Supply Date" where supplies made as detailed below:
01-Mar-2018 - 110
30-Mar-2018 - 90
05-May-2018 - 72
C2: =SUMPRODUCT(A2:A4, B2:B4)/SUM(B2:B4)
Entia non sunt multiplicanda sine necessitate
Thank you very much.
Gorthisubra - please do not hijack other members' threads in future - start your own!
Ali
Enthusiastic self-taught user of MS Excel who's always learning!
Don't forget to say "thank you" in your thread to anyone who has offered you help.
You can reward them by clicking on * Add Reputation below their user name on the left, if you wish.
Forum Rules (updated August 2023): please read them here.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks