Don't know if this will help but you could calculate each individual
community with formulas, either sumproduct or an array formula
"Average".

e.g.
=SUMPRODUCT(--(A1:A100=E1),D1:D100)/COUNTIF(A1:A100,E1)
or
=AVERAGE(IF(A1:A100=E1,D1:D100))
entered with CTRL+SHIFT+ENTER

where
E1 = a community name
A1:A100 = community name column
D1:D100 = ratings

HTH
JG


--
pinmaster
------------------------------------------------------------------------
pinmaster's Profile: http://www.excelforum.com/member.php...fo&userid=6261
View this thread: http://www.excelforum.com/showthread...hreadid=498893