How to make add cells together after a partic
Closed
super_probie
Posts
1
Registration date
Wednesday August 18, 2010
Status
Member
Last seen
August 18, 2010
-
Aug 18, 2010 at 02:15 AM
rizvisa1 Posts 4478 Registration date Thursday January 28, 2010 Status Contributor Last seen May 5, 2022 - Aug 18, 2010 at 07:26 AM
rizvisa1 Posts 4478 Registration date Thursday January 28, 2010 Status Contributor Last seen May 5, 2022 - Aug 18, 2010 at 07:26 AM
Hello,
I am setting up a checkbook ledger in Excel. I am trying to figure out how to make a cell add after the first day of the month.
The D2-J2 cells will add the amounts in from the cells below.
The C1 cell is the total of the D2-J2.
What I am wanting to do is make C1 add up D2-J2 only after the current date falls past the first of the month for each column.
Basically C1 will have the amount of D2 in it until Feb 1st. Then C1 will have the amount in it of D2 and E2. Then after march 1st C1 will have the amount in it of D2-F2. So on so on.
Also in the formula that does this is there a way to not make it year specific. I am wanting to save this as a template and use it for quite some time. I am very new to this. I have only been working with excel for a few months now. Thanks in advance.
I am setting up a checkbook ledger in Excel. I am trying to figure out how to make a cell add after the first day of the month.
The D2-J2 cells will add the amounts in from the cells below.
The C1 cell is the total of the D2-J2.
What I am wanting to do is make C1 add up D2-J2 only after the current date falls past the first of the month for each column.
Basically C1 will have the amount of D2 in it until Feb 1st. Then C1 will have the amount in it of D2 and E2. Then after march 1st C1 will have the amount in it of D2-F2. So on so on.
Also in the formula that does this is there a way to not make it year specific. I am wanting to save this as a template and use it for quite some time. I am very new to this. I have only been working with excel for a few months now. Thanks in advance.
Related:
- How to make add cells together after a partic
- How to add songs to sound picker - Guide
- 2007 microsoft office add-in microsoft save as pdf or xps - Download - Other
- How to add @ in laptop - Guide
- How to add photo in word resume - Guide
- How to add hard drive to pc windows 11 - Guide
1 response
rizvisa1
Posts
4478
Registration date
Thursday January 28, 2010
Status
Contributor
Last seen
May 5, 2022
766
Aug 18, 2010 at 07:26 AM
Aug 18, 2010 at 07:26 AM
Could you please upload a sample EXCEL file WITH sample data, macro, formula , conditional formatting etc on some shared site like https://authentification.site , http://docs.google.com, http://wikisend.com/ , http://www.editgrid.com etc
A N D post back here the link to allow better understanding of how it is now and how you foresee. Based on the sample book, could you re-explain your problem too
A N D post back here the link to allow better understanding of how it is now and how you foresee. Based on the sample book, could you re-explain your problem too