Home |
Search |
Today's Posts |
|
#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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Conditional formatting a full row triggered by a single cell reference... | Excel Worksheet Functions | |||
cell color index comparison | New Users to Excel | |||
up to 7 functions? | Excel Worksheet Functions | |||
Formatting dates in the future | Excel Worksheet Functions | |||
Cell Formatting | Excel Discussion (Misc queries) |