Posted to microsoft.public.excel.misc

bnmohan via OfficeKB.com bnmohan via OfficeKB.com is offline

external usenet poster

Posts: 4

Help with Weighted Average

Would a PivotTable help?

Mohan

Kim wrote:
My sample data only have two cities but the actual data I have consist more
than 50 cities. So what's the best way ?

=SUMPRODUCT(C$2:C$6,D$2:D$6,--(B$2:B$6=B2))/SUMIF(B$2:B$6,B2,D$2:D$6)
--
[quoted text clipped - 29 lines]

Thanks.

--
Message posted via http://www.officekb.com

Reply With Quote

Thread Tools	Search this Thread
Show Printable Version	Search this Thread: Advanced Search
Display Modes
Switch to Linear Mode Hybrid Mode Switch to 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
What is, and should I use Weighted Average?	ArcticWolf	Excel Worksheet Functions	4	January 14th 09 01:50 AM
weighted average	Whitney	Setting up and Configuration of Excel	6	February 6th 08 05:11 PM
Weighted Average	Gage Teacher	Excel Worksheet Functions	2	January 16th 06 04:50 PM
Weighted Average	MedicEric	New Users to Excel	2	November 26th 05 07:29 PM
Non zero weighted average	jeffsfas	Excel Worksheet Functions	10	June 20th 05 08:41 PM

All times are GMT +1. The time now is 02:28 AM.

About Us

"It's about Microsoft Excel"

Menu

About Us