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 / November 2007

Tip: Looking for answers? Try searching our database.

Setting number in cell back to zero

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
Mike - 24 Nov 2007 16:45 GMT
Hi !
I asked this before and got no real answer so here goes again

----A----B----C
1............0              B1  is where I want to enter a number lets say 5
-
2
-
3............0              B3 is where I would like the answer total to be

  So if I enter the 5 in B1 and press enter the 5 will show in B3

 I would like B1 to return to 0 (zero) while still keeping the 5 in B3

 When the next number is entered into B1 say a 4 and enter is pressed B3
would add
  the 5  that is already in B3 to B1 and give an answer of 9 in B3
returning B1 to 0 (zero)
  Adding the numbers is simple but how do I keep the number in B3 while
returning B1 to 0 (zero)
Or how could I lock B3 to so that it could stay as it only allowing it to
increase by the value of what is entered into B1 as all numbers entered into
B1 will always be added to B3 the valve will always be increased never
decreased

Hope someone can help me.
TIA
Mike
=================================

Tell me and I'll forget
Show me and I'll remember
Involve me and I WILL learn

=================================
Niek Otten - 24 Nov 2007 17:04 GMT
Hi Mike,

Look here:

http://www.mcgimpsey.com/excel/accumulator.html

Signature

Kind regards,

Niek Otten
Microsoft MVP - Excel

| Hi !
| I asked this before and got no real answer so here goes again
[quoted text clipped - 31 lines]
|
| =================================
Mike - 25 Nov 2007 05:55 GMT
ThankX will look and read
Mike

> Hi Mike,
>
[quoted text clipped - 41 lines]
> |
> | =================================
 
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.