Running total at bottom of column?

J

Jazz Drummer

I have a column of numbers, at the bottom I want a total. I want to be able
to add new numbers to that column and have the total cell visible at the
bottom of the column and updated with each new entry, how do I do this?
 
J

John

With what you are saying i am thinking you can try Simple Sum function at the
bottom of ur column

=SUM(A1:A10)
 
V

vezerid

Practically speaking, if the numbers to be summed grow in population,
and you still want the sum to appear at the bottom, you need to put the
summation formula way down, to accomodate for the growing list of
numbers.

For example, you can place your summation at row 500.
=SUM(A1:A500)
If so, select the row where you will put the sum, and then menu Window,
and select Split. Make sure the row is the last one appearing on your
screen when you issue the command.

A simpler solution would of course be to have the sum at the top of
another column.

HTH
Kostis Vezerides
 
Top