Adding values in columns with a specific indicator

B

basjakob

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
 
B

basjakob

Its in two or more columns.

Im gonnna try "Teethless mama":s solution when i get home.

Thx
/Jeo
 
Top