View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
bnmohan via OfficeKB.com bnmohan via OfficeKB.com is offline
external usenet poster
 
Posts: 4
Default 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