I have the following table:

A 1
B 2
C 3
D 4
A 5
B 6
C 7
A 8
A 9
A 10
D 11
D 12
C 13
B 14

With the text in column A & the numbers in Column B. The Letters can
change, depending on what has been entered elsewhere.

What I want to do, is calculate the sum of all entries that have a
score of A. In the exmaple of the table above, this would be 33. If
I wanted to know the sum of all entries with a score of B, it would
return 22 etc.

Can anyone help?

Rgds

Duncs