If you don't put any numbers below the data or above the data, you could just
use:

=sum(sheet1!a:a)



Peter Thomas wrote:

Hi,
I have to obtain the sum of a column and then have to have that total
appear in another sheet of the workbook every month in order that I
can keep a track of each month's expenses - so far that is no problem.
However, the length of the column varies each month so I am prevented
from using the absolute reference function - can anyone please suggest
how I may overcome this? I am using Excel 2007
--
Cheers

Peter

--

Dave Peterson