Sum in list

[Arne Hegefors]

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!

 

[vezerid]

Arne,

in C2 use the following formula and copy down:

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

HTH
Kostis Vezerides

 

[Roger Govier]

Hi Arne

One way
In cell C1
=IF(A2=A1,"",SUMIF(A:A,A1,B:B))
copy down as far as required

 

[Arne Hegefors]

thanks! that works fine except for the case where there is a bank with only
one occurence. Any thoughts on this is appreciated!

"vezerid" skrev:

 

[Roger Govier]

Hi Arne

Works fine for me with single occurrence of a bank.
I added to your data, Abbey 150 and Barclays 200 and in column C I get
Null, Null, 274, Null, 460, 150, 200

 

[Arne Hegefors]

Hi! Yes i know that it works when you have the data like that but if you have
eg
citi 100
citi 100
citi 100
rabo 21
abn 50
abn 75
abn 50
then you get in c: null, null, 300, 300, null, null, 175....Pls note the
second 300, there is the problem but I have know idea how to solve it. pls
help me!!

"Roger Govier" skrev:

 

[Roger Govier]

Hi Arne

With that same data in A1:B7
with =IF(A2=A1,"",SUMIF(A:A,A1,B:B))
in cell C1 and copied down, I get

Null, Null, 300, 21, Null, 175

 

[Arne Hegefors]

yes thanks! my mistake! thnx alot!!!

"Roger Govier" skrev:

 

[Roger Govier]

Hi Arne
Glad you got it sorted in the end.