Automatic totals.

[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?

 

[trip_to_tokyo]

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.

 

[trip_to_tokyo]

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).

 

[Eduardo]

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

 

[Zygy]

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?