Excel help

[kiwi]

I'm sure there's some Excel wizards on here (I know, not really programming...)

I'm trying to create a league table out of groups so something like:

Person1 A 25
Person2 A 45
Person3 B 12
Person4 B 72

I need a formula to add up the entries with the same group letter, can anyone help me out?

 

[kiwi]

Brilliant, cheers. I had thought of COUNTIF() but SUMIF() is what I wanted, ta.