yes thanks! my mistake! thnx alot!!!

"Roger Govier" skrev:

Hi Arne

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

--
Regards

Roger Govier


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