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

=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

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

Its in two or more columns.

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

Thx
/Jeo