Adding values in columns with a specific indicator
 

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

Adding values in columns with a specific indicator
 

=SUMIF(B:B,"A",A:A)
=SUMIF(B:B,"B",A:A)

" wrote:

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

Adding values in columns with a specific indicator
 

Is the datta in one column or two?

"Teethless mama" wrote:

=SUMIF(B:B,"A",A:A)
=SUMIF(B:B,"B",A:A)

" wrote:

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

Adding values in columns with a specific indicator
 

Its in two or more columns.

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

Thx
/Jeo