How to Create A Table of Sums sorted by Labels?

[fifty]

I have some data that is of the following format (the column names are different than this, but this is just illustrative):

A 1
B 0
C 1
D 0
A 1
C 1
D 0
B 1
A 1
B 0
D 1
C 0

the letters are in one column, and the numbers are in the next column over.

What I would like to do is get Calc to calculate the sum of what each letter got.

In my example, for instance, I'd like something like:

A: 3
B: 1
C: 2
D: 1

Because if you add the numbers next to "A" through the entire data set, you get 3, etc.

Does this make sense? How do I do this in Calc?
_________________
I LOVE MYSELF

[Leion]

Think you can look at the sumif function

try
=SUMIF(L4:L9;"=A";M4:M9)

replace the L4:L9 to the range that contains your ABC
and replace the M4:M9 with the number range
and replace the =A to =B and so on


see
http://www.openofficetips.com/blog/archives/2004/12/basic_functions_7.html