adding numbers in a single cell as a running total in that cell ?

Leith, what does the second formula do? I like yours way better than mine, so as I add your superior version to my .CLS options, I just want to make sure I fully understand it.

Thanks alot guys for the quick answers I really appreciate the help....I can grasp what your saying but im not sure where to make the changes in those macros. I have'nt had to use a macro for anything yet and know nothing about them. i am making a weekly list that includes 7 days and prices for paid line items each has a 25 cells in a colum and 1 colum for each day of the week. so the range of cells that need this macro to make it work for this sheet would be cells d3 to j3 all the way down to d28 to j28 and all of them inside that...... would i have to do that for every one of those boxes ? or would that macro work for the whole page? will I need to input header coordinates for each macro:? lol sorry.

Hello JB,

The Selection_Change() event records the cell's value before it is changed and saves it in the variable Prev. When the cell 's contents change, the Worksheet_Change() event fires. The current contents are then added to the previous value.