=SUMIF(A1:A100,"A",B1:B100)
or
=SUMIF(A:A,"A",B:B)
best wsihes
--
Bernard V Liengme
www.stfx.ca/people/bliengme
remove caps from email

"Duncs" wrote in message
ps.com...
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