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?

 

[ricky1981]

Sounds like you need sumif, as an example this would give you the total for group A.

=SUMIF(B1:B5,"A",C1:C5)

Obviously you will need to adjust b1:b5 and c1:c5 depending how many people you have.

 

[kiwi]

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