Automatic totals.
 

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?

Automatic totals.
 

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.







"Zygy" wrote:

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?

.

Automatic totals.
 

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

"trip_to_tokyo" wrote:

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.







"Zygy" wrote:

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?

.

Automatic totals.
 

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" wrote:

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?

.

Automatic totals.
 

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?
"trip_to_tokyo" wrote in message
...
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).

"trip_to_tokyo" wrote:

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.







"Zygy" wrote:

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?

.