Hi Anton, XL can almost do what you want, which may be sufficient for you.
If you want to be able to enter your grocery expenditure always in the same cell, XL can accumulate those entries in another cell using VBA. For example, You may enter your grocery expenditure always into A2, but the actual accumulated total would appear in A3 (or any other cell you like). This can be done by clicking a button after each entry into A2, or XL can monitor changes to A2 and do the accumulation automatically. If this suits your purpose, there are lots of us in the group who could help you achieve this. Regards - Dave. > Date: Wed, 23 Jun 2010 11:22:58 -0700 > Subject: $$Excel-Macros$$ how to get cumulative sum in a cell > From: a...@kwic.com > To: excel-macros@googlegroups.com > > Dear Group, > I am constructing a single entry accounting spreadsheet in excel. i > would like to input numbers for, say grocery expenses, in a cell of > fixed location. when I buy more groceries i would like to type in the > new expense in the same cell so that the output of that cell is the > cumulative total expenses for groceries. > any way to do this in excel? > Thanks for reading, > anton > > -- > ---------------------------------------------------------------------------------- > Some important links for excel users: > 1. Follow us on TWITTER for tips tricks and links : > http://twitter.com/exceldailytip > 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 > 3. Excel tutorials at http://www.excel-macros.blogspot.com > 4. Learn VBA Macros at http://www.quickvba.blogspot.com > 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com > > To post to this group, send email to excel-macros@googlegroups.com > > <><><><><><><><><><><><><><><><><><><><><><> > HELP US GROW !! > > We reach over 7000 subscribers worldwide and receive many nice notes about > the learning and support from the group.Let friends and co-workers know they > can subscribe to group at > http://groups.google.com/group/excel-macros/subscribe _________________________________________________________________ Need a new place to live? Find it on Domain.com.au http://clk.atdmt.com/NMN/go/157631292/direct/01/ -- ---------------------------------------------------------------------------------- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com <><><><><><><><><><><><><><><><><><><><><><> HELP US GROW !! We reach over 7000 subscribers worldwide and receive many nice notes about the learning and support from the group.Let friends and co-workers know they can subscribe to group at http://groups.google.com/group/excel-macros/subscribe
