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

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 ( '_' )" <(E-Mail Removed)> wrote in message
news:(E-Mail Removed)...
>
> 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
>
>

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 ( '_' )" <(E-Mail Removed)> wrote in message
news:(E-Mail Removed)...
>
> 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
>
>

Hi Laura,

It can be done but only with a Change event macro! Do you really want this
instead of a simpler method: entering your numbers in A2, A3, etc. and click
on Autosum in the next cell when you finished?

Regards,
Stefi

„Laura ( '_' )â€� ezt Ã*rta:

>
> 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
>
>
>

A code solution

Private Sub Worksheet_Change(ByVal Target As Range)
Const WS_RANGE As String = "$A$2"

On Error GoTo ws_exit:
Application.EnableEvents = False
If Target.Address = WS_RANGE Then
With Target
.Offset(1, 0).Value = .Value + .Offset(1, 0).Value
End With
End If

ws_exit:
Application.EnableEvents = True
End Sub

'This is worksheet event code, which means that it needs to be
'placed in the appropriate worksheet code module, not a standard
'code module. To do this, right-click on the sheet tab, select
'the View Code option from the menu, and paste the code in.


--
HTH

Bob Phillips

(remove nothere from email address if mailing direct)

"Laura ( '_' )" <(E-Mail Removed)> wrote in message
news:(E-Mail Removed)...
>
> 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
>
>

I would prefer it the easier way, but my office boss has asked me to find a
way to do it by inputting the data in just one cell, so i have to find out
how to do it.

And to make it even WORSE, i have sum sort of bug on my computer which wont
let me go on the internet or access links (im getting that sorted in another
newsgroup at the mo!)

So, if you could explain it to me, i would be *SO* grateful!
Thanks

--
@---}--
Laura.....
Liverpool, England

"Stefi" <(E-Mail Removed)> wrote in message
news:E0E86720-0937-473C-B4DD-(E-Mail Removed)...
> Hi Laura,
>
> It can be done but only with a Change event macro! Do you really want this
> instead of a simpler method: entering your numbers in A2, A3, etc. and
click
> on Autosum in the next cell when you finished?
>
> Regards,
> Stefi
>
> "Laura ( '_' )" ezt írta:
>
> >
> > 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
> >
> >
> >

Hiya, Im sorry but i really dont have a clue what that is or what to do with
it.
Im sorry but im very very new :-S

--
@---}--
Laura.....
Liverpool, England

"Bob Phillips" <(E-Mail Removed)> wrote in message
news:e$PJ$(E-Mail Removed)...
> A code solution
>
> Private Sub Worksheet_Change(ByVal Target As Range)
> Const WS_RANGE As String = "$A$2"
>
> On Error GoTo ws_exit:
> Application.EnableEvents = False
> If Target.Address = WS_RANGE Then
> With Target
> .Offset(1, 0).Value = .Value + .Offset(1, 0).Value
> End With
> End If
>
> ws_exit:
> Application.EnableEvents = True
> End Sub
>
> 'This is worksheet event code, which means that it needs to be
> 'placed in the appropriate worksheet code module, not a standard
> 'code module. To do this, right-click on the sheet tab, select
> 'the View Code option from the menu, and paste the code in.
>
>
> --
> HTH
>
> Bob Phillips
>
> (remove nothere from email address if mailing direct)
>
> "Laura ( '_' )" <(E-Mail Removed)> wrote in message
> news:(E-Mail Removed)...
> >
> > 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
> >
> >
>
>

Open the worksheet it is to apply to, follow the instructions at the end of
the code, go back to the worksheet and put some numbers in A2.

--
HTH

Bob Phillips

(remove nothere from email address if mailing direct)

"Laura ( '_' )" <(E-Mail Removed)> wrote in message
news:%(E-Mail Removed)...
> Hiya, Im sorry but i really dont have a clue what that is or what to do
with
> it.
> Im sorry but im very very new :-S
>
> --
> @---}--
> Laura.....
> Liverpool, England
>
> "Bob Phillips" <(E-Mail Removed)> wrote in message
> news:e$PJ$(E-Mail Removed)...
> > A code solution
> >
> > Private Sub Worksheet_Change(ByVal Target As Range)
> > Const WS_RANGE As String = "$A$2"
> >
> > On Error GoTo ws_exit:
> > Application.EnableEvents = False
> > If Target.Address = WS_RANGE Then
> > With Target
> > .Offset(1, 0).Value = .Value + .Offset(1, 0).Value
> > End With
> > End If
> >
> > ws_exit:
> > Application.EnableEvents = True
> > End Sub
> >
> > 'This is worksheet event code, which means that it needs to be
> > 'placed in the appropriate worksheet code module, not a standard
> > 'code module. To do this, right-click on the sheet tab, select
> > 'the View Code option from the menu, and paste the code in.
> >
> >
> > --
> > HTH
> >
> > Bob Phillips
> >
> > (remove nothere from email address if mailing direct)
> >
> > "Laura ( '_' )" <(E-Mail Removed)> wrote in message
> > news:(E-Mail Removed)...
> > >
> > > 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
> > >
> > >
> >
> >
>
>

Okay thanks Bob. I did what you asked, but when I type in A2, I get an error
message "Syntax error". Then the top line of the code you gave me highlights
yellow.
This is how i have it in my spreadsheet:

Private Sub Worksheet_Change(ByVal Target As Range)
Const WS_RANGE As String = "$A$2"

On Error GoTo ws_exit:
Application.EnableEvents = False
If Target.Address = WS_RANGE Then
With Target.
Offset(1, 0).Value = .Value + .Offset(1, 0).Value
End With
End If

ws_exit:
Application.EnableEvents = True
End Sub



Thanks,you've been very helpful so far

--
@---}--
Laura.....
Liverpool, England

"Bob Phillips" <(E-Mail Removed)> wrote in message
news:(E-Mail Removed)...
> Open the worksheet it is to apply to, follow the instructions at the end
of
> the code, go back to the worksheet and put some numbers in A2.
>
> --
> HTH
>
> Bob Phillips
>
> (remove nothere from email address if mailing direct)
>
> "Laura ( '_' )" <(E-Mail Removed)> wrote in message
> news:%(E-Mail Removed)...
> > Hiya, Im sorry but i really dont have a clue what that is or what to do
> with
> > it.
> > Im sorry but im very very new :-S
> >
> > --
> > @---}--
> > Laura.....
> > Liverpool, England
> >
> > "Bob Phillips" <(E-Mail Removed)> wrote in message
> > news:e$PJ$(E-Mail Removed)...
> > > A code solution
> > >
> > > Private Sub Worksheet_Change(ByVal Target As Range)
> > > Const WS_RANGE As String = "$A$2"
> > >
> > > On Error GoTo ws_exit:
> > > Application.EnableEvents = False
> > > If Target.Address = WS_RANGE Then
> > > With Target
> > > .Offset(1, 0).Value = .Value + .Offset(1, 0).Value
> > > End With
> > > End If
> > >
> > > ws_exit:
> > > Application.EnableEvents = True
> > > End Sub
> > >
> > > 'This is worksheet event code, which means that it needs to be
> > > 'placed in the appropriate worksheet code module, not a standard
> > > 'code module. To do this, right-click on the sheet tab, select
> > > 'the View Code option from the menu, and paste the code in.
> > >
> > >
> > > --
> > > HTH
> > >
> > > Bob Phillips
> > >
> > > (remove nothere from email address if mailing direct)
> > >
> > > "Laura ( '_' )" <(E-Mail Removed)> wrote in message
> > > news:(E-Mail Removed)...
> > > >
> > > > 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
> > > >
> > > >
> > >
> > >
> >
> >
>
>

A cell formula does not have memory (of previous values in a cell). The
only way to build in memory is with VBA (You chould have a worksheet
change event that updates the cell when there is a change in the cell)
http://www.mcgimpsey.com/excel /accumulator.html
which will be a stretch given your lack of experience in Excel.

As a practical matter, memory in a calculation is almost always a bad
idea. How would you deal with data entry errors in the cell? If the
running total somehow gets out of sync, how would you correct, or even
detect it?

Scudo's suggestion is a far more robust approach.

Sorry about the multi-post reply -- Comcast has apparently instituted a
new policy that does not permit a simultaneous reply to all of the
original groups.

Jerry

Laura ( '_' ) wrote:

> I would prefer it the easier way, but my office boss has asked me to find a
> way to do it by inputting the data in just one cell, so i have to find out
> how to do it.
>
> And to make it even WORSE, i have sum sort of bug on my computer which wont
> let me go on the internet or access links (im getting that sorted in another
> newsgroup at the mo!)
>
> So, if you could explain it to me, i would be *SO* grateful!
> Thanks