Summing an entire column in Excel

  • Thread starter Thread starter Burn-z
  • Start date Start date
B

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?
 
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.
 
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.
 
Back
Top