Welcome to Windows Help!
FAQFAQ    SearchSearch      ProfileProfile    Private MessagesPrivate Messages   Log inLog in

Adding up several cells

 
   Windows Help (Home) -> Microsoft Excel RSS
Next:  Simplifying Data  
Author Message
JD

External


Since: Jan 19, 2009
Posts: 1



(Msg. 1) Posted: Mon Jan 19, 2009 9:25 am
Post subject: Adding up several cells
Archived from groups: microsoft>public>excel (more info?)

I'm sure this is really easy but I am getting into circular reference
errors - I have two cells - one is a running total the other a user input
figure that needs to be appended to the running total every time. so if the
running total stands at 0, the user inputs 10 into the second cell and the
running total updates to 10. If the second cell is then changed to 15, the
running total should reflect 25. Is this possible??

thanks

 >> Stay informed about: Adding up several cells 
Back to top
Login to vote
Don Guillett

External


Since: Oct 18, 2008
Posts: 18



(Msg. 2) Posted: Mon Jan 19, 2009 9:25 am
Post subject: Re: Adding up several cells
Archived from groups: per prev. post (more info?)

Right click sheet tab>view code>insert this.
Now when you change a3 cell b3 will reflect the increase

Private Sub Worksheet_Change(ByVal target As Excel.Range)
If Intersect(target, Range("a1:a13")) Is Nothing _
Or IsNumeric(target) = False Then Exit Sub
Application.EnableEvents = False
target.Offset(, 1) = target.Offset(, 1) + target
Application.EnableEvents = True
End Sub

 >> Stay informed about: Adding up several cells 
Back to top
Login to vote
Pete_UK

External


Since: Dec 4, 2008
Posts: 17



(Msg. 3) Posted: Mon Jan 19, 2009 9:25 am
Post subject: Re: Adding up several cells
Archived from groups: per prev. post (more info?)

This link shows you how to do it:

[URL="http://www.mcgimpsey.com/excel/accumulator.html"]http://www.mcgimpsey.com/excel/accumulator.html[/URL]

Hope this helps.

Pete

On Jan 19, 12:59 pm, "JD" wrote:
> I'm sure this is really easy but I am getting into circular reference
> errors - I have two cells - one is a running total the other a user input
> figure that needs to be appended to the running total every time. so if the
> running total stands at 0, the user inputs 10 into the second cell and the
> running total updates to 10. If the second cell is then changed to 15, the
> running total should reflect 25. Is this possible??
>
> thanks
 >> Stay informed about: Adding up several cells 
Back to top
Login to vote
Display posts from previous:   
Related Topics:
Unlocking Cells - Hi, I'd like to know if there's a simple way to unlock or lock cells. I'm not sure if "Lock" is the correct term here. For example, if you have a formula that has C$14. Is there an easy way to unlock (remove the "$") from the formul...

Copy cells with value 0 as a list - Hi, I have a sheet with some cells with value 0 and others with data. I want a macro that copies all the cells with value <>0 in other sheet but as a list, one under the other. Is this possible? Thanks!

fill blank cells in a column - hello, how can i fill specific blank cells in a column. i tried find/replace without success. thanks

How to Past cells with formulas not using "$" without chan.. - Hello, I would like to copy / past a large amount of cells in which "$" has not been used in formules. Problem : referenced are changed (because "$" is not there). Example in A1 : "=B1+C1" if I copy A1 to A50 : the con...

Excel 2008 hanges when deleting cells or rows -
   Windows Help (Home) -> Microsoft Excel All times are: Pacific Time (US & Canada)
Page 1 of 1

 
You can post new topics in this forum
You can reply to topics in this forum
You can edit your posts in this forum
You can delete your posts in this forum
You can vote in polls in this forum



[ Contact us | Terms of Service/Privacy Policy ]