I have some columns looking like this:

1 B
4 B
3 A
3 B
8 A
1 A
3 A
6 B

and it continues forever.

I want to add sum the values that have an A indicator and the values
that have a B indicator.
Like this:

A = 3 + 8 + 1 + 3 = 15
B = 1 + 4 + 3 + 6 = 14

if i use autofilter i can add them manually, but my list is very long
and numbers will be added later too, so it would be convinient to have
some sort of formula doin the job for me.

Thankful for any help
/Jakob