AutoSum a Column

[MGumbrell]

Hi all

I have a worksheet that within column G I enter my mileage (a row each day).

What I currently have
At the top within the Freeze panes is a =Sum(G5:G234) which clearly adds up all the mileage from G5:G234. The only downfall is that I have to keep adjusting it each time the data goes beyond this formula. I know that I could set the formula to reach the last row reference. However

What i would like
To use a formula with xldn, I think that this is right for looking at a column. I am also aware that its possible for Excel to carry out this fuction stopping at the last entry in that column.

What is the clearest/cleanest way to add consecutive data in a column.

Thank you, Matt

 

[DCrake]

Use the following formula

=SUMIF(G:G,">0")

David

 

[Brianwarnock]

When I had to do something like this I used to insert the latest data at the top after all who wants to find the last row every time, then , using your example G5:G234 and increasing , the actual data was from G6 and I inserted a fresh row below G5 for the new data, and Excel adjusts the formala.

Brian

 

[HaHoBe]

Hi, Matt,

if you use Excel2003 just use Data/List. Or use a dynamic range according to Update Charts Automatically When You Enter New Data (only use the part with Names and Offset ).

Ciao,
Holger

 

[MGumbrell]

Thank you Guys

Regards, Matt