What formula to use to sum subtotals by next cell meaning

[VCK]

I am sure there should be some formula in excel to use to get the result I want. I need a formula to look into one column and sum up totals from other column which have the same value in first column.

Example of data:

A 1000
B 5
A 300
A 72
B 41

The result I need to get:

A 1372
B 46

Meaning getting the totals of second column for the same value in the first column.

I would highly appreciate your help and hints.

[romperstomper]

You can use SUMIF:
=SUMIF(A:A,"A",B:B)
and
=SUMIF(A:A,"B",B:B)
for example.

[VCK]

Thanks for the idea.

Will it work in case there will be more values in first column than just A & B? Could be A, B, C, etc...

I just gave a short example in order to make it simple to understand.

[romperstomper]

It will sum based on whatever criteria you specify. If you want to produce the whole summary, then use a pivot table and put the column A data into the row field area and the column B data into the data area. The will produce exactly what you want.

[VCK]

Trying with pivots now. Tried before but didn't work. Maybe this time more luck.

Anyway, ideas about functions are also very welcome

[VCK]

Pivot worked for me.