 |
 | 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 / New Users / April 2007running total
Excuse the primitive nature of the question; I searched for the answer in a couple of Excel groups, but I suspect it's so simple that the question isn't asked. I rarely use Excel, but I need to produce a running total: I want each cell in column B to contain the total of the cells in column A starting with A1 thru the current row in column A. So: B1=A1, B2=A1+A2, B3=A1+A2+A3, etc. I can't figure how to specify a formula that I can copy into each cell in column B to accomplish this. I'm assuming that I can use SUM, but I can't seem to find a way to specify the cell range so that copying the formula from one cell in column B, to the remaining cells in column B, retains the correct cell references. Thanks. In B1 put =SUM($A$1:A1) then copy the formula down as long as needed  SignatureRegards, Peo Sjoblom > Excuse the primitive nature of the question; I searched for the answer in > a couple of Excel groups, but I suspect it's so simple that the question [quoted text clipped - 12 lines] > > Thanks. Thanks, just what I needed. > In B1 put > [quoted text clipped - 18 lines] >> cells in column B, retains the correct cell references. >> Thanks. Try it this way: B1: =A1 B2: =A2+B1 B3: =A3+B2 Copy B2 (or B3) down for as many values as you have in column A. Hope this helps. Pete > Excuse the primitive nature of the question; I searched for the > answer in a couple of Excel groups, but I suspect it's so simple [quoted text clipped - 13 lines] > > Thanks. I was playing with something like this, but never got it quite right. Thanks. > Try it this way: > [quoted text clipped - 8 lines] > > Pete >> Excuse the primitive nature of the question; I searched >> for the answer in a couple of Excel groups, but I [quoted text clipped - 14 lines] >> >> Thanks. Hi John Just a note. If it is going to be a long list, then although both Peo's method and Pete's achieve the same result. the number of processes that Excel has to perform to get the answer is much reduced in Pete's solution, so it will be faster. On a small range, you won't notice the difference. SignatureRegards Roger Govier >I was playing with something like this, but never got it quite right. >Thanks. [quoted text clipped - 30 lines] >>> >>> Thanks. Hello Roger, another thing is if the results in B are derived from for example a formula where the result can be a "blank" like "" then the formula using operators will return a value error while SUM will ignore any text SignatureRegards, Peo Sjoblom > Hi John > [quoted text clipped - 40 lines] >>>> >>>> Thanks. Hi Peo Yes that is quite correct. It's just that I am ever mindful of the timings that David McRitchie posted when there are large ranges involved http://snipurl.com/1gbgf and since then I have usually avoided this type of formula I suppose one could overcome the problem of summing blanks by using =N(A2)+B1 SignatureRegards Roger Govier > Hello Roger, > [quoted text clipped - 47 lines] >>>>> >>>>> Thanks. Thank you all. I love the internet and newsgroups, and those who help. I'm saving all this; hopefully next time I won't need to ask. > Hi Peo > [quoted text clipped - 67 lines] >>>>>> remaining cells in column B, retains the correct >>>>>> cell references. Thanks. |
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.