Insert before the last row in your formula
or
create a defined name
or
=SUM(A2:OFFSET(A2,MATCH(9999999,A:A),0))
--
Don Guillett
SalesAid Software

"CrazySwayze" wrote in message
ups.com...
I have a spreadsheet that requires the constant addition of new rows
of data and I need the sheet to automatically recalculate the desired
totals to include the new row. I am fairly new to macros and was
seeking some basic direction on how to program this.