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!
|