In simplest form for data given.

=IF(SUMIF(K:K,"a",J:J)SUMIF(K:K,"b",J:J),"A","B")
--
Don Guillett
Microsoft MVP Excel
SalesAid Software

"andim" wrote in message
...
Hi

I am fairly sure this can be done but I don't know how.

I have three columns of data in a sheet. Column A holds the names of
individuals, Column B holds a number which represents that individual's
score
and column C holds a letter which shows the group (team) that the
individual
belongs to.

Tom 2 A
Ann 3 B
Jim 1 A
May 5 B

I have a formula which shows the individual with the highest score.
I just need a formula (maybe an array would do it, i'm not sure) that will
show the group with the highest overall score.

There are actually 13 teams and 130 people.

Thanks in advance.