sum in list

[nada]

Hi! I have a long list with bank names and depost values. The list of banks is sorted based on bank names. One bank can occur several times in the list (but since it is sorted they come after each other). I want to have the sum of deposit values for every bank. How can this be done?
Example:
Cititgroup 120
Cititgroup 100
Cititgroup 54
ABN 320
ABN 140
etc.

I want to have a third column with the sums like this:

Cititgroup 120
Cititgroup 100
Cititgroup 54 274
ABN 320
ABN 140 460
etc.

Any help very much appreciated! Thanks alot!

 

[Aladin Akyurek]

Hi! I have a long list with bank names and depost values. The list of banks is sorted based on bank names. One bank can occur several times in the list (but since it is sorted they come after each other). I want to have the sum of deposit values for every bank. How can this be done?
Example:
Cititgroup 120
Cititgroup 100
Cititgroup 54
ABN 320
ABN 140
etc.

I want to have a third column with the sums like this:

Cititgroup 120
Cititgroup 100
Cititgroup 54 274
ABN 320
ABN 140 460
etc.

Any help very much appreciated! Thanks alot!

C2, copied down:

=IF(A2<>A3,SUMIF($A$2:A2,A2,$B$2:B2),"")

 

[Richard Schollar]

Hi

Sounds like a SUMIF would suit your needs:

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

where A and B columns holds your list of names and balances and C1 holds the name of the bank for which you wish to sum for.

Best regards

Richard

EDIT: Please ignore my post - completely misread the requirement. I'll leave it up as a monument to my own stupidity

 

[nada]

hi! Thanks that works fine except when there is a bank with only one occurence. Please help me with this! thanks alot!

 

[Aladin Akyurek]

hi! Thanks that works fine except when there is a bank with only one occurence. Please help me with this! thanks alot!

What is wrong with a bank with only one occurrence?