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