 |
 | Home | Contact Us | FAQ | Search & Site Map | Link to Us |
 | Sign In | Join | Other 45 Sites in Network |
| HomeDiscussionsAccessExcelInfoPathOutlookPowerPointPublisherWordDirectoryUser Groups Related Topics Outlook ExpressInternet ExplorerWindowsMS Server ProductsMore Topics ... |
MS Office Forum / Excel / Worksheet Functions / October 2006Sum in list
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! Arne, in C2 use the following formula and copy down: =IF(A3<>A2,SUMIF(A:A,A2,B:B),"") HTH Kostis Vezerides > 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 [quoted text clipped - 18 lines] > > Any help very much appreciated! Thanks alot! 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, > [quoted text clipped - 27 lines] > > > > Any help very much appreciated! Thanks alot! 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  SignatureRegards Roger Govier > thanks! that works fine except for the case where there is a bank with > only [quoted text clipped - 36 lines] >> > >> > Any help very much appreciated! Thanks alot! 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 > [quoted text clipped - 42 lines] > >> > > >> > Any help very much appreciated! Thanks alot! 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 SignatureRegards Roger Govier > Hi! Yes i know that it works when you have the data like that but if > you have [quoted text clipped - 65 lines] >> >> > >> >> > Any help very much appreciated! Thanks alot! Hi Arne One way In cell C1 =IF(A2=A1,"",SUMIF(A:A,A1,B:B)) copy down as far as required SignatureRegards Roger Govier > Hi! I have a long list with bank names and depost values. The list of > banks [quoted text clipped - 21 lines] > > Any help very much appreciated! Thanks alot! yes thanks! my mistake! thnx alot!!! "Roger Govier" skrev: > Hi Arne > [quoted text clipped - 28 lines] > > > > Any help very much appreciated! Thanks alot! Hi Arne Glad you got it sorted in the end. SignatureRegards Roger Govier > yes thanks! my mistake! thnx alot!!! > [quoted text clipped - 34 lines] >> > >> > Any help very much appreciated! Thanks alot! |
Reply to this Message |
 Sign In
 Join
 My Latest Posts My Monitored Threads My Blog My Photo Gallery My Profile My Homepage Start New Thread Enable EMail Alerts Rate this Thread
|
©2008 Advenet LLC Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.