Hello,
I browsed many conversations on weighted averages and did not find a solution to my problem. My apologizes if I jumped over it.
Over 3 columns I got:
col 1 = product (text) ; col 2 = price (number) ; col 3 = volume (number)
For each product there can be many prices and different volumes.
My goal is to calculate the weighted average for each product automatically.
I know SUMPRODUCT(blabla)/sum(blabla) does weighted averages but I cannot find the syntax to do it on a per product base.
I hope I am clear
p.
Bookmarks