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
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.
Related:

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
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
0