Use SUMPRODUCT:

=SUMPRODUCT(--(A1:A10="A"),--(B1:B10)) and repeat for each letter whose
corresponding values you want to sum.

Dave
--
Brevity is the soul of wit.


"Steve" wrote:

I have a spreadsheet that has 2 columns, column A are values that repeat such
a A, B,C. Column 2 are numeric values. I want to add all A's, all B's, all
C's like such. How do I accomplish this? I am completely new to Excel. Thanks
for all help in advance.

Column A Column B Totals
A 1 A 2
B 1 B 2
C 1 C 2
A 1
B 1
C 1