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:

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

--
Regards

Roger Govier


"Arne Hegefors" wrote in
message ...
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:

Arne,

in C2 use the following formula and copy down:

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

HTH
Kostis Vezerides

Arne Hegefors wrote:
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!