Home |
Search |
Today's Posts |
#1
|
|||
|
|||
In 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? |
#2
|
|||
|
|||
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 -- Michael Mitchelson "PFHMoney" wrote: 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? |
#3
|
|||
|
|||
Or if the OP never leaves any blanks in-between one can use a dynamic range
click insertnamedefine, 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 "Michael" wrote: 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 -- Michael Mitchelson "PFHMoney" wrote: 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? |
#4
|
|||
|
|||
Good Point Peo.
However, I was sticking with KISS principle Michael -- Michael Mitchelson "Peo Sjoblom" wrote: Or if the OP never leaves any blanks in-between one can use a dynamic range click insertnamedefine, 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 "Michael" wrote: 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 -- Michael Mitchelson "PFHMoney" wrote: 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? |
#5
|
|||
|
|||
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. -- Don Guillett SalesAid Software "PFHMoney" wrote in message ... 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? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
excel self total | Excel Discussion (Misc queries) | |||
Does excel recognise names rather than cells? | Excel Worksheet Functions | |||
How do I flip a column in excel (top becomes bottom)? | Excel Worksheet Functions | |||
Column A is Town, Column B is names. How can Excel add & tell how. | Charts and Charting in Excel | |||
Set up barcode column in Excel | Excel Worksheet Functions |