Automatic totals.

  • Thread starter Thread starter Zygy
  • Start date Start date
Z

Zygy

When you get to 90 the memory is not what it used to be! I have done this in
the past years countless times, but now I have forgotten how to do it - i.e.
how do I arrange an automatic total sum in the last cell of figures in a
column?
 
Simple example in EXCEL 2007:-

1. Enter the number 1 in cells A 1 to A 5 inclusive.

2. In cell A 6:-

Home / Editing / click the AutoSum button / this should automatically
highlight the range A 1 to A 5 / click on the tick sign (immediately the the
left of fx)

3. The total:-

5

- should now be placed into cell A 6.

4. A6 has the following formula in it:-

=SUM(A1:A5)

If my comments have helped please hit Yes.

Thanks.
 
In EXCEL 2003 there is a:-

Σ

- button on the toolbar.

This is the AutoSum function that I have used in my previous posting (in
cell A 6).
 
Hi,

=subtotal(9,A1:A100)

The advantage of the above formula is that if you need to filter the column
it will give you the sum only for the filtered data
 
Hi, Thank you for the reply. I use Excel 2003 and I am aware of the Sum
button on the toolbar, but what I have in my other worksheets is an
automatic change in the total cell for the column if you make any entry (
addition or deletion) of a sum e.g. if I have the following in the column:-
200.00
300.00
400.00
900.00 total which will change automatically to 1,000.00 if I enter
additional 100.00 of will change automatically to 800.00 if I delete the
first cell of 100.00.
How do I arrange for the automatic change in the total cell?
 
Back
Top