Hi Everyone,
I am new to this forum and could do with some help.
I want to create a year to date total in a cell, if for example like a payslip when the total in say A1 changes I need A2 to remeber the original figure and add the new figure in A1
so if in april i earn 1000.00
ytd = 1000.00
may is 200.00
I want the ytd to remember the 1000 and add the 200 to give me 1200.
Not sure if this makes sense
Can you post an example spreadsheet that contains the info you want? What you say makes sense, but I want to see how you have the spreadsheet formatted to make this as easy as possible.
1N73LL1G3NC3 15 7H3 4B1L17Y 70 4D4P7 70 CH4NG3 - 573PH3N H4WK1NG
You don't have to add Rep if I have helped you out (but it would be nice), but please mark the thread as SOLVED if your issue is resolved.
Tom
Hi,
Thank you for coming back to me,
c10 =SUM($B$10:$B10) and drag down.
See the attached file.
Notice my main language is not English.
I appreciate it, if you reply on my solution.
If you are satisfied with the solution, please mark the question solved.
You can add reputation by clicking on the star * add reputation.
oeldere, that would be the simplest solution, which is the route I was thinking of going, but I'm not sure that's what the OP is looking for. I think this might need to use VBA and not a formula.
@gmr4evr1
No need for VBA in this example.
Pivot table will also be an option.
Is there a way to have a cell "remember" what it is and add the value of another cell to it?
@gmr4evr1
maybe like this
c10 = b10
c11 = c10+b11
If OP wants VBA, I figured it out. Place the code below in Sheet1 (or whichever sheet you are using) of VBA editor
This code is for the example workbook you (the OP) posted
Please Login or Register to view this content.
oeldere,
sorry, c10 = b10
c11 = c10+b11
didn't work either
@gmr4evr1
Seen your code I'm thinking it does not add the cummulative value in E4 if an value is added in c4.
it does for me, did you test it in my added file?Please Login or Register to view this content.
The way the OP's example workbook is set up, he/she is using cells C3 (Gross) and E3 (Total). In this case, the VBA does work, I tested it in the example I downloaded from the OP. It keeps a "running" total in cell E3 and adds C3 to it whenever C3 changes.
Last edited by gmr4evr1; 03-08-2015 at 09:44 AM.
Ok, on your sheet it "does" work if the OP was adding additional rows of data. If I read it correctly the OP wants to use just one row, with the same 3 cells each time.
We will wait on the respond of OP.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks