Summing an entire column in Excel

[Burn-z]

I am working on an excel sheet for expenses. Each time an expense is added it
is added to the end. I want a total at the top of the page. I do not want to
update the SUM formula each time a line item is added. If I sum from E7
through E10000 I get the correct answer even if cells E50 through E10000 are
blank but, when I try to print it, it gives me 67 blank pages. Is there a way
to find the total that will automatically sum only the fields that have
information in them and not hard code the last cell?

 

[Douglas J. Steele]

Sorry, but this newsgroup is for questions about Access, the database
product that's part of Office Professional.

You'd be best off reposting your question to a newsgroup related to Excel.

 

[MikeJohnB]

As Doug says, this is Access News Group but you can do it like this

=SUM(A:A)

placed in a cell not on the A column will sum the whole of A column.
Substitute A:A for your column.