single cell formula

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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.
 
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
 
A big thanks to Paul B for his fast and useful response. Much appreciated!
All the info was on the link provided.
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Excel VBA 1
Excel Need Countifs Formula Help 0
Excel How to run multiple Private Sub Worksheet_Change(ByVal Target As Range) 0
Excel In Excel how can I block the contenent of a cell? 0
Excel VBA to move cells to sheet2 based on selection in sheet1 0
Add a new row in Named Table (Table1) and add data from txtboxes into last empty cells based on header named of the Table1 0
Excel formula, sum the value cell and if empty cell left blank 0
Scrabble Value calculation for Welsh words 0

Back
Top