 |
 | 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 / May 2005In excel - how to total column if am not sure of the last cell
I am attempting to track mileage within an excel spreadsheet... with each entry being enter into the spreadsheet similar to that of a checkbook register... I have no idea how many entries there will be for the year, so my question is how to have a running total of sorts whereby the last entry (be it 2 or 200 cells later) will have a total? Hi Say your data is in columns A to D, and your mileages are in D, In cell E1, put =SUM(D:D) This will sum everythin in column D, and your total will always be in the same location regardless of column length HTH Michael  SignatureMichael Mitchelson > I am attempting to track mileage within an excel spreadsheet... with each > entry being enter into the spreadsheet similar to that of a checkbook [quoted text clipped - 3 lines] > is how to have a running total of sorts whereby the last entry (be it 2 or > 200 cells later) will have a total? Or if the OP never leaves any blanks in-between one can use a dynamic range click insert>name>define, give it a name like MyRange, in the Refers to box put =OFFSET(Sheet1!$D$1,,,COUNTA(Sheet1!$D:$D),) click OK then use =SUM(MyRange) which will adapt to any new entries in the D column Regards, Peo Sjoblom > Hi > Say your data is in columns A to D, and your mileages are in D, In cell E1, [quoted text clipped - 13 lines] > > is how to have a running total of sorts whereby the last entry (be it 2 or > > 200 cells later) will have a total? Good Point Peo. However, I was sticking with KISS principle Michael SignatureMichael Mitchelson > Or if the OP never leaves any blanks in-between one can use a dynamic range > click insert>name>define, give it a name like MyRange, in the Refers to box [quoted text clipped - 31 lines] > > > is how to have a running total of sorts whereby the last entry (be it 2 or > > > 200 cells later) will have a total? As I read your question you want the total to be the LAST entry in the column. If so, just put in your cell a21 =sum(a2:a20) if row 20 is your last row. Then insert new rows before the sum formula and Excel will adjust or put your total at the TOP and use =sum(a2:a2000). Or, you can use a worksheet change macro to automate replacing the last cell with the total regardless of what you do or where you put the new figure. SignatureDon Guillett SalesAid Software donaldb@281.com > I am attempting to track mileage within an excel spreadsheet... with each > entry being enter into the spreadsheet similar to that of a checkbook [quoted text clipped - 3 lines] > is how to have a running total of sorts whereby the last entry (be it 2 or > 200 cells later) will have a total? |
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.