Hi, hope you can help me with this.

I've got a large spreadsheet with a large group of people split into 5 teams
(ie teams A to E) in no particular order. this spreadsheet show the results
of some recent tests. I want the sum of the scores for the people in each
team.
For example

Team Name Score
A Bob 15
B Janet 17
B Sam 8
A Alan 12
C Chris 15

And so on and so forth. If I wanted the sum of the scores for the people in
team A, how would I go about doing this?