If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
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? |
#2
|
|||
|
|||
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? . |
#3
|
|||
|
|||
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? . |
#4
|
|||
|
|||
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? . |
#5
|
|||
|
|||
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? . |
Thread Tools | |
Display Modes | |
|
|