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

you would need for example

A1 307
A2 400
A3 total 707

If you put the total in say A10 then every `number` from A1 to A9 would be
in the total



"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