Sum if....

[elmaco12]

Hi guys,

I have this excel problem... I have one column A, with alot of fourdigit numbers. In column B there are amounts that are connected to the number in A. Example:

A B
1125 15000
1126 35000
1126 40000
1127 5000
1130 28000
1130 1500
...
and so on..

what I need to do is to look through column A, and find all cells with the same value (in column A that is), then summerize their connected value in column B. This i would like to be created in column C and D. So for the example above the result would be:

A B C D
1125 15000 1125 5000
1126 35000 1126 75000
1126 40000 1127 5000
1127 5000 1130 29500
1130 28000 ...
1130 1500
...

I would prefere not using any macros and such, since i will have to translate everything to my stupid swedish excelbook =)...

is this possible?


Best regads,

M

[mubashir aziz]

The best thing to do use of Pivot Table ....... Else first you have sort out unique record from Column A and then paste them on some location and then by using sumif formula you can do it easily .....................

[windknife]

Try this,
C2

Please Login or Register  to view this content.

Commit With Ctrl+Shift+Enter

D2

Please Login or Register  to view this content.

You also can see attached file.

Hope this helps,

windknife

[mubashir aziz]

simply awesome WK ......