If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Cell formatting
I am trying to create a spread for my business. I am trying to get Excel to
add a number to an existing number and keep a running count then remove the number I entered. Example say I enter 1.95 to 2.35 I can get that to add but cannot keep adding to the first column. Any help would be appricated. |
#2
|
|||
|
|||
I can't really tell from your description, but this might be what you're
looking for: http://www.mcgimpsey.com/excel/accumulator.html In article , "Sundance" wrote: I am trying to create a spread for my business. I am trying to get Excel to add a number to an existing number and keep a running count then remove the number I entered. Example say I enter 1.95 to 2.35 I can get that to add but cannot keep adding to the first column. Any help would be appricated. |
#3
|
|||
|
|||
"Sundance" wrote: I am trying to create a spread for my business. I am trying to get Excel to add a number to an existing number and keep a running count then remove the number I entered. Example say I enter 1.95 to 2.35 I can get that to add but cannot keep adding to the first column. Any help would be appricated. This worked to a degree. What I need now is to be able to remove the 2nd cells figure at the end of the month without losing the formula. And have it clear the 1st cell after the entry for the next entry. |
#4
|
|||
|
|||
You can get all you need to know right in this place and the best part is on video I got a lot of my begginer help on this site... cool www.MDOTutorials.com -- Route2391 ------------------------------------------------------------------------ Route2391's Profile: http://www.excelforum.com/member.php...o&userid=26774 View this thread: http://www.excelforum.com/showthread...hreadid=399686 |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
How do I Count Colors in a cell with conditional formatting | JB | General Discussion | 3 | September 2nd, 2004 12:41 AM |
Formatting cell colour based on colour of other cell | Marta | Worksheet Functions | 2 | June 16th, 2004 05:27 PM |
Conditional Formatting Based On Content Of Another Cell | Jay | Worksheet Functions | 6 | June 11th, 2004 12:48 PM |
Conditional Formatting on a cell that has an IF function | DDM | Worksheet Functions | 0 | May 11th, 2004 05:13 PM |
Do you have what it takes... | Frank Kabel | Worksheet Functions | 1 | February 22nd, 2004 08:30 PM |