Jc, have a look here for a way to do it, and why not to do it,

http://www.mcgimpsey.com/excel/accumulator.html
--
Paul B
Always backup your data before trying something new
Please post any response to the newsgroups so others can benefit from it
Feedback on answers is always appreciated!
Using Excel 2002 & 2003

"Jc" wrote in message
...
Hi,
How do I get single cells within a sheet to keep on adding up every time I
add a value? Cell B1 has the value 1, if I later type in 1 it should then
auto add to show the value 2, another 1 then shows value 3 and so on. Any
ideas will be appreciated, thanks.