Home | Contact Us | FAQ | Search & Site Map | Link to Us
Sign In | Join | Other 45 Sites in Network
Home
DiscussionsAccessExcelInfoPathOutlookPowerPointPublisherWord
DirectoryUser Groups
Related Topics
Outlook ExpressInternet ExplorerWindowsMS Server ProductsMore Topics ...

MS Office Forum / Excel / New Users / January 2006

Tip: Looking for answers? Try searching our database.

adding number in next cell

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
ED - 11 Jan 2006 16:12 GMT
Every  month I have to change the sales amount in my worksheet.  I would
like this amount to be added automatically to the total for the year sales
amount in the next cell.  Is this possible?
RagDyeR - 11 Jan 2006 16:52 GMT
Of course it's possible!

If you would like a suggested formula:

=SUM($A$1:A1)

Now, if this doesn't work for you, how would I know that, with all the
information that you gave us?
Signature


Regards,

RD
----------------------------------------------------------------------------
-------------------
Please keep all correspondence within the Group, so all may benefit !
----------------------------------------------------------------------------
-------------------

Every  month I have to change the sales amount in my worksheet.  I would
like this amount to be added automatically to the total for the year sales
amount in the next cell.  Is this possible?
Don Guillett - 11 Jan 2006 16:52 GMT
right click sheet tab>view code>insert this>modify a10 to your cell>SAVE

Private Sub Worksheet_Change(ByVal Target As Range)
If Target.Address <> "$A$10" Then Exit Sub
Target.Offset(, 1) = Target.Offset(, 1) + Target
End Sub

Signature

Don Guillett
SalesAid Software
dguillett1@austin.rr.com

>
> Every  month I have to change the sales amount in my worksheet.  I would
> like this amount to be added automatically to the total for the year sales
> amount in the next cell.  Is this possible?
ED - 11 Jan 2006 21:10 GMT
I guess I should explain myself a bit better.
Every month I enter the actual sales amount in Cell C13,  then in Cell D13 I
enter the cummulative sales amount for the year (which I calculate manually).
The following month I enter the new actual sales amount in Cell C13 and I
add this amount to the previous cummulative sales amount from the previous
month in Cell D13.   Can D13 be updated automatically with a formula every
time I enter a new amount in Cell C13?

> Every  month I have to change the sales amount in my worksheet.  I would
> like this amount to be added automatically to the total for the year sales
> amount in the next cell.  Is this possible?
Don Guillett - 11 Jan 2006 21:44 GMT
Why not just qualify Rag's offering with an IF
or
modify mine

Private Sub Worksheet_Change(ByVal Target As Range)
  'If Target.Address <> "$A$10" Then Exit Sub
If Target.Column <> 1 Then Exit Sub
Target.Offset(, 1) = Target.Offset(-1, 1) + Target
End Sub

Signature

Don Guillett
SalesAid Software
dguillett1@austin.rr.com

>I guess I should explain myself a bit better.
> Every month I enter the actual sales amount in Cell C13,  then in Cell D13
[quoted text clipped - 10 lines]
>> sales
>> amount in the next cell.  Is this possible?
 
Sign In
Join
My Latest Posts
My Monitored Threads
My Blog
My Photo Gallery
My Profile
My Homepage

Start New Thread
Enable EMail Alerts
Rate this Thread



©2008 Advenet LLC   Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.