Thread: Sum in list
View Single Post
  #6   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Roger Govier Roger Govier is offline
external usenet poster
 
Posts: 2,886
Default Sum in list

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

--
Regards

Roger Govier


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