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

Use the following formula

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

David

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

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 (http://spreadsheetpage.com/index.php/tip/update_charts_automatically_when_you_enter_new_dat a/) (only use the part with Names and Offset ;)).

Ciao,
Holger

Thank you Guys

Regards, Matt