Posted to microsoft.public.excel.misc
|
|
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
|