In excel - how to total column if am not sure of the last cell

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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
 
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
 
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.
 
Back
Top