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.

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.

"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.

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