Thanks for this. Created a pivot table and it works just fine. !
"Terry Tipsy" wrote:

A pivot table would work nicely for what I think you are looking for. Once
set up you could easily get team averages. A 'Help' or 'Web' will give you a
lot of information on how to do this.
--
T Tipsy