Posted to microsoft.public.excel.worksheet.functions

PhilF

external usenet poster

Posts: 4

Weighted Averages

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.

Reply With Quote

Thread Tools	Search this Thread
Show Printable Version	Search this Thread: Advanced Search
Display Modes
Switch to Linear Mode Switch to Hybrid Mode Threaded Mode

Posting Rules
Smilies are On [IMG] code is On HTML code is Off Trackbacks are On Pingbacks are On Refbacks are On

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Weighted Averages for Rankings	katie	Excel Worksheet Functions	1	April 8th 09 05:33 PM
Weighted Averages?	Kevin	Excel Worksheet Functions	5	April 2nd 09 02:55 PM
weighted averages in a pivot table - how?	Vic	Excel Worksheet Functions	0	April 22nd 08 07:07 PM
Calculating weighted averages	rgl	Excel Discussion (Misc queries)	6	February 22nd 06 06:15 PM
Weighted Averages in Excel	Karl	Excel Discussion (Misc queries)	2	February 9th 06 12:36 PM

All times are GMT +1. The time now is 10:49 AM.

About Us

"It's about Microsoft Excel"

Menu

About Us