Thank you for trying to help--but I realize I may not have explained my
problem in enough detail. I have sales of a group of products, each with a
different list price, different number of units sold, different net
receipts for each product, and hence a different discount. I calculated a
discount for each product by dividing the total proceeds of each product's
sales by the number of units, then dividing the result by the list price of
the product, which gave me a percentage discount. What I am now attempting
to find is the average discount for the group, weighted by the amount of
sales. Using the Average function on the column of average discounts gives
me an average of the averages, not a weighted average. I'm not sure your
reply is valid because I inadequately explained my problem. Thanks again for
your help.

Phil F.

on "Sheikh Saadi" wrote:


Sppose you have Product Price in Column B and Qty in Column C, use this
formula to calculate weighted avg:

= SUMPRODUCT(B2:B10, C2:C10) / SUM(C2:C10)

Hope this will help...

--
Sheikh Saadi


"PhilF" wrote:

Can anyone enlighten me how to calc a weighted averages of a column of
averages? I have calculated the average discount of product sales (ie, each
sale has a different discount), and i want to get a weighted average of of
the sum of them. I'm pretty much stumped.

Thanks.