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.







"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?
>
> .
>

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

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

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" <(E-Mail Removed)> wrote in message
news:29AA188F-8038-44CE-97D1-(E-Mail Removed)...
> 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?
>> >
>> > .
>> >