Sequentially adding a day to total
A B C D E F G H
4 |Month| J J A S O N YTD
5 |Heading|1.00|1.00|1.00|1.00|1.00|1.00| 3.00
In the above example, the letters above the numbers identify the month.
(J-June J-July A-Aug S-Sept O-Oct N-Nov and the numbers are money)
I am looking for a formula that will add only the numbers in row 5 up to the
current month but not past that. So above, I wish it to add June, July and
Aug in this example.
At the end of August, I wish the formula to know that we are in September
now and Add the total from September to the previous months (Row 5, column
B,C and D)
This formula is for a calendar year.
Thank you in advance for your help.
-BadBoy
|