Thread: Adding on excel
View Single Post
  #3   Report Post  
Posted to microsoft.public.excel,microsoft.public.excel.newusers
Max
 
Posts: n/a
Default Adding on excel

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