Perhaps better to simply use an adjacent top cell
to total up successive inputs down col A ?
Put in say, B1: =SUM(A:A)
B1 will return the total of the numbers entered down col A
If you really want to accumulate by inputting repeatedly into A2,
try JE McGimpsey's page at:
http://www.mcgimpsey.com/excel/accumulator.html
Look for:
- Single cell accumulator
- Worksheet Function Accumulator (using Circular References)
--
Rgds
Max
xl 97
---
Singapore, GMT+8
xdemechanik
http://savefile.com/projects/236895
--
"Laura ( '_' )" wrote in message
...
Excel 2000
Hiya, I have a question for all you brainboxes out there!
Im VERY new to excel so please explain clearly or I'll be completley
lost!!
In the cell A3 I would like to have a "Grand Total".
In the cell A2, I would like to enter a number, eg. 400 (this would then
appear in A3 as 400), THEN I would like to enter another number, eg. 307
in
cell A2. (this wouuld then appear in A3 as 707).
I hope that explains it, I find it a bit confusing.
Thanks for any help you can offer :)
--
@---}--
Laura..... :)
Liverpool, England