Home |
Search |
Today's Posts |
#1
![]() |
|||
|
|||
![]()
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. |
#2
![]() |
|||
|
|||
![]()
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. |
#3
![]() |
|||
|
|||
![]()
A big thanks to Paul B for his fast and useful response. Much appreciated!
All the info was on the link provided. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Returning the formula in a cell | Excel Discussion (Misc queries) | |||
Pasting Word table cell with paragraph markers into single Excel c | Excel Discussion (Misc queries) | |||
need help creating formula based on cell value | Excel Discussion (Misc queries) | |||
GET.CELL | Excel Worksheet Functions | |||
Cell doesn't show formula result - it shows formula (CTRL + ' doe. | Excel Worksheet Functions |