« Webquery: Scraping FOREX quotes from Yahoo | Main | Adding notes to cells »
November 09, 2004
Calculating weighted average
We will look at how to use the SUMPRODUCT function to determine the weighted average value for some sales data.In the example below, averaging the prices of each product does not give a correct average sale. We need to use the SUMPRODUCT function as illustrated to determine the weighted average of the sales.
Posted by Dave at November 9, 2004 06:19 AM
Comments
thanks a lot, this is just what i was looking for! :)
Posted by: jana at November 26, 2004 09:16 PM