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?

.