totals troubles

  • Thread starter Thread starter yankele
  • Start date Start date
Y

yankele

Having some trouble using the AutoSum feature in
Excel2000. I have a list of numbers in one of several
columns. To make a total of those numbers I use the
AutoSum feature to insert a total at the bottom of the
column. I then add subsequent entries and I wish to have a
cumulative total at the bottom of the column. I tried
using the AutoSum feature, selecting the first total and
the subsequent entries, but the new total I get is only of
the subsequent entries. Can AutoSum do this or do I have
to enter a formula to get the job done?
Thanks.
 
yankele said:
Having some trouble using the AutoSum feature in
Excel2000. I have a list of numbers in one of several
columns. To make a total of those numbers I use the
AutoSum feature to insert a total at the bottom of the
column. I then add subsequent entries and I wish to have a
cumulative total at the bottom of the column. I tried
using the AutoSum feature, selecting the first total and
the subsequent entries, but the new total I get is only of
the subsequent entries. Can AutoSum do this or do I have
to enter a formula to get the job done?
Thanks.
Click to expand...

AutoSum is only a quick way of entering a formula! Look at the second
formula that you have entered; I suspect that it doesn't include in its sum
range the cell with the first sum in it.
 
Hi

It is often simpler to have your total at the top of the column when you
have an expanding set of data, and to use the Subtotal function

Insert a new row above your existing headins / data
Assuming the coumn where you wish to have the total is column D, then in D1
enter
=SUBTOTAL(9,D3:D1000)

If you apply Freeze frames to the top 2 rows, than your total will always be
visible and will always include any additional rows you have added within
the range specified. Change ranges to suit.
 
There are various ways including a dynamic range. But here is a simple way.
Let's say you will eventually have no more than 100 items in each column.
To sum column A use =SUM(A1:A100) - it does not matter that initially some
of the cells are empty.
Best wishes
 
yankele,
Is the first SUM adjacent to the subsequent entries? If not, you can hold down the control key to select non-contiguous cells. If you don't hold the control key then excel will replace the first selection with the second.

As an aside, holding the shift key selects all cells between two selected cells.

Good Luck,
Mark Graesser
(e-mail address removed)

----- yankele wrote: -----

Having some trouble using the AutoSum feature in
Excel2000. I have a list of numbers in one of several
columns. To make a total of those numbers I use the
AutoSum feature to insert a total at the bottom of the
column. I then add subsequent entries and I wish to have a
cumulative total at the bottom of the column. I tried
using the AutoSum feature, selecting the first total and
the subsequent entries, but the new total I get is only of
the subsequent entries. Can AutoSum do this or do I have
to enter a formula to get the job done?
Thanks.
 
Back
Top