SUMIF formula to add months prior to current date?

[Ardina13]

I am currently using excel 2007. I am trying to build a formula that will do a SUMIF based on the current date and adding all months prior to the current date. The data that is being shown is arranged by month in 3 sets of columns per month (goal, actual, percentages). The goals are inputted into the spreadsheet 6 months at a time. The actual data is input into the spreadsheet each month. I want to have the year to date data show only the data for the time frame that has already passed for each of the 3 columns (matching the monthly setup), but not for the future months' goals. I've already verified that the formula doesn't require an array, but I don't know why it keeps returning a "0". Here's my formula:

=SUM(IF(MONTH(TODAY())>7,C3,0),IF(MONTH(TODAY())>8,F3,0),IF(MONTH
(TODAY())>9,I3,0),IF(MONTH(TODAY())>10,L3,0),IF(MONTH(TODAY())>11,O3,
0),IF(MONTH(TODAY())>12,R3,0),IF(MONTH(Today())<7,U3,0)

The last part (IF(MONTH(Today())<7,U3,0)) is because once the new fiscal year has started, I still need to be able to see whether the goals were met for the first 6 months, and that data is then also pulled and added into the 2nd 6 months through a different formula (which is working except nothing is showing for the 1st 6 months).

Please let me know if there's anything I can answer to make my question more clear, and thank you!

 

[yogeshmaney]

Can you provide sample data and your requirements /expected results.?

 

[Ardina13]

Sure, here's a sample - and there's clarification below as well:

<table border="0" cellpadding="0" cellspacing="0" width="1969"><col style="width: 101pt;" width="134"> <col style="width: 83pt;" width="110"> <col style="width: 56pt;" span="20" width="75"> <col style="width: 56pt;" span="2" width="75"> <col style="width: 56pt;" width="75"> <tbody><tr style="height: 12.75pt;" height="17"> <td class="xl67" style="height: 12.75pt; width: 101pt;" height="17" width="134">Name</td> <td class="xl68" style="width: 83pt;" width="110">July</td> <td class="xl68" style="width: 56pt;" width="75">
</td> <td class="xl68" style="width: 56pt;" width="75">
</td> <td class="xl68" style="width: 56pt;" width="75">Aug</td> <td class="xl68" style="width: 56pt;" width="75">
</td> <td class="xl68" style="width: 56pt;" width="75">
</td> <td class="xl68" style="width: 56pt;" width="75">Sept</td> <td class="xl68" style="width: 56pt;" width="75">
</td> <td class="xl68" style="width: 56pt;" width="75">
</td> <td class="xl68" style="width: 56pt;" width="75">Oct</td> <td class="xl68" style="width: 56pt;" width="75">
</td> <td class="xl68" style="width: 56pt;" width="75">
</td> <td class="xl68" style="width: 56pt;" width="75">Nov</td> <td class="xl68" style="width: 56pt;" width="75">
</td> <td class="xl68" style="width: 56pt;" width="75">
</td> <td class="xl68" style="width: 56pt;" width="75">Dec</td> <td class="xl68" style="width: 56pt;" width="75">
</td> <td class="xl68" style="width: 56pt;" width="75">
</td> <td class="xl68" style="width: 56pt;" width="75">J-D Metric</td> <td class="xl68" style="width: 56pt;" width="75">J-D Actual</td> <td class="xl68" style="width: 56pt;" width="75">Diff</td> <td class="xl68" style="width: 56pt;" width="75">YTD</td> <td class="xl68" style="width: 56pt;" width="75">YTD</td> <td class="xl68" style="width: 56pt;" width="75">
</td> </tr> <tr style="height: 12.75pt;" height="17"> <td class="xl69" style="height: 12.75pt;" height="17">
</td> <td class="xl68">Metric</td> <td class="xl68">Actual</td> <td class="xl68">Diff</td> <td class="xl68">Metric</td> <td class="xl68">Actual</td> <td class="xl68">Diff</td> <td class="xl68">Metric</td> <td class="xl68">Actual</td> <td class="xl68">Diff</td> <td class="xl68">Metric</td> <td class="xl68">Actual</td> <td class="xl68">Diff</td> <td class="xl68">Metric</td> <td class="xl68">Actual</td> <td class="xl68">Diff</td> <td class="xl68">Metric</td> <td class="xl68">Actual</td> <td class="xl68">Diff</td> <td class="xl68">
</td> <td class="xl68">
</td> <td class="xl68">
</td> <td class="xl68">Metric</td> <td class="xl68">Actual</td> <td class="xl68">Diff</td> </tr> <tr style="height: 12.75pt;" height="17"> <td class="xl76" style="height: 12.75pt;" height="17">primary </td> <td class="xl77">8</td> <td class="xl78">8</td> <td class="xl79" style="font-size: 10pt; color: rgb(51, 153, 102); font-weight: 400; text-decoration: none; font-family: Arial; border-width: 0.5pt 0.5pt medium medium; border-style: solid solid none none; border-color: windowtext windowtext -moz-use-text-color -moz-use-text-color;">0</td> <td class="xl77" style="border-left: medium none;">8</td> <td class="xl78">8</td> <td class="xl79" style="font-size: 10pt; color: rgb(51, 153, 102); font-weight: 400; text-decoration: none; font-family: Arial; border-width: 0.5pt 0.5pt medium medium; border-style: solid solid none none; border-color: windowtext windowtext -moz-use-text-color -moz-use-text-color;">0</td> <td class="xl77" style="border-left: medium none;">8</td> <td class="xl78">8
</td> <td class="xl79" style="font-size: 10pt; color: rgb(51, 153, 102); font-weight: 400; text-decoration: none; font-family: Arial; border-width: 0.5pt 0.5pt medium medium; border-style: solid solid none none; border-color: windowtext windowtext -moz-use-text-color -moz-use-text-color;">0</td> <td class="xl77" style="border-left: medium none;">8</td> <td class="xl78">8
</td> <td class="xl79" style="font-size: 10pt; color: rgb(51, 153, 102); font-weight: 400; text-decoration: none; font-family: Arial; border-width: 0.5pt 0.5pt medium medium; border-style: solid solid none none; border-color: windowtext windowtext -moz-use-text-color -moz-use-text-color;">0</td> <td class="xl77" style="border-left: medium none;">
</td> <td class="xl78">8</td> <td class="xl79" style="font-size: 10pt; color: rgb(51, 153, 102); font-weight: 400; text-decoration: none; font-family: Arial; border-width: 0.5pt 0.5pt medium medium; border-style: solid solid none none; border-color: windowtext windowtext -moz-use-text-color -moz-use-text-color;">0</td> <td class="xl77" style="border-left: medium none;">8</td> <td class="xl78">8</td> <td class="xl79" style="font-size: 10pt; color: rgb(51, 153, 102); font-weight: 400; text-decoration: none; font-family: Arial; border-width: 0.5pt 0.5pt medium medium; border-style: solid solid none none; border-color: windowtext windowtext -moz-use-text-color -moz-use-text-color;">0</td> <td class="xl77" style="border-left: medium none;">48</td> <td class="xl78">48</td> <td class="xl79" style="font-size: 10pt; color: rgb(51, 153, 102); font-weight: 400; text-decoration: none; font-family: Arial; border-width: 0.5pt 0.5pt medium medium; border-style: solid solid none none; border-color: windowtext windowtext -moz-use-text-color -moz-use-text-color;">0</td> <td class="xl77" style="border-left: medium none;">0</td> <td class="xl78">0</td> <td class="xl79" style="font-size: 10pt; color: rgb(51, 153, 102); font-weight: 400; text-decoration: none; font-family: Arial; border-width: 0.5pt 0.5pt medium medium; border-style: solid solid none none; border-color: windowtext windowtext -moz-use-text-color -moz-use-text-color;">0</td> </tr> <tr style="height: 12.75pt;" height="17"> <td class="xl76" style="height: 12.75pt;" height="17">primary 1</td> <td class="xl81">4</td> <td class="xl76">4</td> <td class="xl82" style="font-size: 10pt; color: rgb(51, 153, 102); font-weight: 400; text-decoration: none; font-family: Arial; border-width: medium 0.5pt medium medium; border-style: none solid none none; border-color: -moz-use-text-color windowtext -moz-use-text-color -moz-use-text-color;">0</td> <td class="xl81" style="border-left: medium none;">4</td> <td class="xl76">4</td> <td class="xl82" style="font-size: 10pt; color: rgb(51, 153, 102); font-weight: 400; text-decoration: none; font-family: Arial; border-width: medium 0.5pt medium medium; border-style: none solid none none; border-color: -moz-use-text-color windowtext -moz-use-text-color -moz-use-text-color;">0</td> <td class="xl81" style="border-left: medium none;">4</td> <td class="xl76">4
</td> <td class="xl82" style="font-size: 10pt; color: rgb(51, 153, 102); font-weight: 400; text-decoration: none; font-family: Arial; border-width: medium 0.5pt medium medium; border-style: none solid none none; border-color: -moz-use-text-color windowtext -moz-use-text-color -moz-use-text-color;">0</td> <td class="xl81" style="border-left: medium none;">4</td> <td class="xl76">4
</td> <td class="xl82" style="font-size: 10pt; color: rgb(51, 153, 102); font-weight: 400; text-decoration: none; font-family: Arial; border-width: medium 0.5pt medium medium; border-style: none solid none none; border-color: -moz-use-text-color windowtext -moz-use-text-color -moz-use-text-color;">0</td> <td class="xl81" style="border-left: medium none;">
</td> <td class="xl76">4</td> <td class="xl82" style="font-size: 10pt; color: rgb(51, 153, 102); font-weight: 400; text-decoration: none; font-family: Arial; border-width: medium 0.5pt medium medium; border-style: none solid none none; border-color: -moz-use-text-color windowtext -moz-use-text-color -moz-use-text-color;">0</td> <td class="xl81" style="border-left: medium none;">4</td> <td class="xl76">4</td> <td class="xl82" style="font-size: 10pt; color: rgb(51, 153, 102); font-weight: 400; text-decoration: none; font-family: Arial; border-width: medium 0.5pt medium medium; border-style: none solid none none; border-color: -moz-use-text-color windowtext -moz-use-text-color -moz-use-text-color;">0</td> <td class="xl81" style="border-left: medium none;">24</td> <td class="xl76">24</td> <td class="xl82" style="font-size: 10pt; color: rgb(51, 153, 102); font-weight: 400; text-decoration: none; font-family: Arial; border-width: medium 0.5pt medium medium; border-style: none solid none none; border-color: -moz-use-text-color windowtext -moz-use-text-color -moz-use-text-color;">0</td> <td class="xl81" style="border-left: medium none;">0</td> <td class="xl76">0</td> <td class="xl82" style="font-size: 10pt; color: rgb(51, 153, 102); font-weight: 400; text-decoration: none; font-family: Arial; border-width: medium 0.5pt medium medium; border-style: none solid none none; border-color: -moz-use-text-color windowtext -moz-use-text-color -moz-use-text-color;">0</td> </tr> <tr style="height: 12.75pt;" height="17"> <td class="xl83" style="height: 12.75pt;" height="17">primary conversion</td> <td class="xl72">50.0%</td> <td class="xl70">50.0%</td> <td class="xl71" style="font-size: 10pt; color: rgb(51, 153, 102); font-weight: 400; text-decoration: none; font-family: Arial; border-width: medium 0.5pt 0.5pt medium; border-style: none solid solid none; border-color: -moz-use-text-color windowtext windowtext -moz-use-text-color;">0.0%</td> <td class="xl72" style="border-left: medium none;">50.0%</td> <td class="xl70">50.0%</td> <td class="xl71" style="font-size: 10pt; color: rgb(51, 153, 102); font-weight: 400; text-decoration: none; font-family: Arial; border-width: medium 0.5pt 0.5pt medium; border-style: none solid solid none; border-color: -moz-use-text-color windowtext windowtext -moz-use-text-color;">0.0%</td> <td class="xl72" style="border-left: medium none;">50.0%</td> <td class="xl70">50.0%</td> <td class="xl71" style="font-size: 10pt; color: rgb(51, 153, 102); font-weight: 400; text-decoration: none; font-family: Arial; border-width: medium 0.5pt 0.5pt medium; border-style: none solid solid none; border-color: -moz-use-text-color windowtext windowtext -moz-use-text-color;">0.0%</td> <td class="xl72" style="border-left: medium none;">50.0%</td> <td class="xl70">50.0%</td> <td class="xl71" style="font-size: 10pt; color: rgb(51, 153, 102); font-weight: 400; text-decoration: none; font-family: Arial; border-width: medium 0.5pt 0.5pt medium; border-style: none solid solid none; border-color: -moz-use-text-color windowtext windowtext -moz-use-text-color;">0.0%</td> <td class="xl72" style="border-left: medium none;">50.0%</td> <td class="xl70">50.0%</td> <td class="xl71" style="font-size: 10pt; color: rgb(51, 153, 102); font-weight: 400; text-decoration: none; font-family: Arial; border-width: medium 0.5pt 0.5pt medium; border-style: none solid solid none; border-color: -moz-use-text-color windowtext windowtext -moz-use-text-color;">0.0%</td> <td class="xl72" style="border-left: medium none;">50.0%</td> <td class="xl70">50.0%</td> <td class="xl71" style="font-size: 10pt; color: rgb(51, 153, 102); font-weight: 400; text-decoration: none; font-family: Arial; border-width: medium 0.5pt 0.5pt medium; border-style: none solid solid none; border-color: -moz-use-text-color windowtext windowtext -moz-use-text-color;">0.0%</td> <td class="xl72" style="border-left: medium none;">50.0%</td> <td class="xl70">50.0%</td> <td class="xl71" style="font-size: 10pt; color: rgb(51, 153, 102); font-weight: 400; text-decoration: none; font-family: Arial; border-width: medium 0.5pt 0.5pt medium; border-style: none solid solid none; border-color: -moz-use-text-color windowtext windowtext -moz-use-text-color;">0.0%</td> <td class="xl72" style="border-left: medium none;"> </td> <td class="xl70"> </td> <td class="xl71" style="font-size: 10pt; color: rgb(51, 153, 102); font-weight: 400; text-decoration: none; font-family: Arial; border-width: medium 0.5pt 0.5pt medium; border-style: none solid solid none; border-color: -moz-use-text-color windowtext windowtext -moz-use-text-color;"> </td> </tr> <tr style="height: 12.75pt;" height="17"> <td class="xl73" style="height: 12.75pt;" height="17"> </td> <td class="xl73"> </td> <td class="xl74" style="border-top: medium none;"> </td> <td class="xl73"> </td> <td class="xl73"> </td> <td class="xl74" style="border-top: medium none;"> </td> <td class="xl73"> </td> <td class="xl73"> </td> <td class="xl74" style="border-top: medium none;"> </td> <td class="xl73"> </td> <td class="xl73"> </td> <td class="xl74" style="border-top: medium none;"> </td> <td class="xl73"> </td> <td class="xl73"> </td> <td class="xl74" style="border-top: medium none;"> </td> <td class="xl73"> </td> <td class="xl73"> </td> <td class="xl73"> </td> <td class="xl73"> </td> <td class="xl73"> </td> <td class="xl73"> </td> <td class="xl73"> </td> <td class="xl73"> </td> <td class="xl73"> </td> <td class="xl73"> </td> </tr> <tr style="height: 12.75pt;" height="17"> <td class="xl76" style="height: 12.75pt;" height="17">secondary</td> <td class="xl77">16</td> <td class="xl78">16</td> <td class="xl79" style="font-size: 10pt; color: rgb(51, 153, 102); font-weight: 400; text-decoration: none; font-family: Arial; border-width: 0.5pt 0.5pt medium medium; border-style: solid solid none none; border-color: windowtext windowtext -moz-use-text-color -moz-use-text-color;">0</td> <td class="xl77" style="border-left: medium none;">16</td> <td class="xl78">16</td> <td class="xl79" style="font-size: 10pt; color: rgb(51, 153, 102); font-weight: 400; text-decoration: none; font-family: Arial; border-width: 0.5pt 0.5pt medium medium; border-style: solid solid none none; border-color: windowtext windowtext -moz-use-text-color -moz-use-text-color;">0</td> <td class="xl77" style="border-left: medium none;">16</td> <td class="xl78">16
</td> <td class="xl79" style="font-size: 10pt; color: rgb(51, 153, 102); font-weight: 400; text-decoration: none; font-family: Arial; border-width: 0.5pt 0.5pt medium medium; border-style: solid solid none none; border-color: windowtext windowtext -moz-use-text-color -moz-use-text-color;">0</td> <td class="xl77" style="border-left: medium none;">16</td> <td class="xl78">16
</td> <td class="xl79" style="font-size: 10pt; color: rgb(51, 153, 102); font-weight: 400; text-decoration: none; font-family: Arial; border-width: 0.5pt 0.5pt medium medium; border-style: solid solid none none; border-color: windowtext windowtext -moz-use-text-color -moz-use-text-color;">0</td> <td class="xl77" style="border-left: medium none;">16</td> <td class="xl78">16</td> <td class="xl79" style="font-size: 10pt; color: rgb(51, 153, 102); font-weight: 400; text-decoration: none; font-family: Arial; border-width: 0.5pt 0.5pt medium medium; border-style: solid solid none none; border-color: windowtext windowtext -moz-use-text-color -moz-use-text-color;">0</td> <td class="xl77" style="border-left: medium none;">16</td> <td class="xl78">16</td> <td class="xl79" style="font-size: 10pt; color: rgb(51, 153, 102); font-weight: 400; text-decoration: none; font-family: Arial; border-width: 0.5pt 0.5pt medium medium; border-style: solid solid none none; border-color: windowtext windowtext -moz-use-text-color -moz-use-text-color;">0</td> <td class="xl77" style="border-left: medium none;">96</td> <td class="xl78">96</td> <td class="xl79" style="font-size: 10pt; color: rgb(51, 153, 102); font-weight: 400; text-decoration: none; font-family: Arial; border-width: 0.5pt 0.5pt medium medium; border-style: solid solid none none; border-color: windowtext windowtext -moz-use-text-color -moz-use-text-color;">0</td> <td class="xl77" style="border-left: medium none;">0</td> <td class="xl78">0</td> <td class="xl79" style="font-size: 10pt; color: rgb(51, 153, 102); font-weight: 400; text-decoration: none; font-family: Arial; border-width: 0.5pt 0.5pt medium medium; border-style: solid solid none none; border-color: windowtext windowtext -moz-use-text-color -moz-use-text-color;">0</td> </tr> <tr style="height: 12.75pt;" height="17"> <td class="xl76" style="height: 12.75pt;" height="17">secondary 1</td> <td class="xl81">8</td> <td class="xl76">8</td> <td class="xl82" style="font-size: 10pt; color: rgb(51, 153, 102); font-weight: 400; text-decoration: none; font-family: Arial; border-width: medium 0.5pt medium medium; border-style: none solid none none; border-color: -moz-use-text-color windowtext -moz-use-text-color -moz-use-text-color;">0</td> <td class="xl81" style="border-left: medium none;">8</td> <td class="xl76">8</td> <td class="xl82" style="font-size: 10pt; color: rgb(51, 153, 102); font-weight: 400; text-decoration: none; font-family: Arial; border-width: medium 0.5pt medium medium; border-style: none solid none none; border-color: -moz-use-text-color windowtext -moz-use-text-color -moz-use-text-color;">0</td> <td class="xl81" style="border-left: medium none;">8</td> <td class="xl76">8
</td> <td class="xl82" style="font-size: 10pt; color: rgb(51, 153, 102); font-weight: 400; text-decoration: none; font-family: Arial; border-width: medium 0.5pt medium medium; border-style: none solid none none; border-color: -moz-use-text-color windowtext -moz-use-text-color -moz-use-text-color;">0</td> <td class="xl81" style="border-left: medium none;">8</td> <td class="xl76">8
</td> <td class="xl82" style="font-size: 10pt; color: rgb(51, 153, 102); font-weight: 400; text-decoration: none; font-family: Arial; border-width: medium 0.5pt medium medium; border-style: none solid none none; border-color: -moz-use-text-color windowtext -moz-use-text-color -moz-use-text-color;">0</td> <td class="xl81" style="border-left: medium none;">8</td> <td class="xl76">8</td> <td class="xl82" style="font-size: 10pt; color: rgb(51, 153, 102); font-weight: 400; text-decoration: none; font-family: Arial; border-width: medium 0.5pt medium medium; border-style: none solid none none; border-color: -moz-use-text-color windowtext -moz-use-text-color -moz-use-text-color;">0</td> <td class="xl81" style="border-left: medium none;">8</td> <td class="xl76">8</td> <td class="xl82" style="font-size: 10pt; color: rgb(51, 153, 102); font-weight: 400; text-decoration: none; font-family: Arial; border-width: medium 0.5pt medium medium; border-style: none solid none none; border-color: -moz-use-text-color windowtext -moz-use-text-color -moz-use-text-color;">0</td> <td class="xl81" style="border-left: medium none;">48</td> <td class="xl76">48</td> <td class="xl82" style="font-size: 10pt; color: rgb(51, 153, 102); font-weight: 400; text-decoration: none; font-family: Arial; border-width: medium 0.5pt medium medium; border-style: none solid none none; border-color: -moz-use-text-color windowtext -moz-use-text-color -moz-use-text-color;">0</td> <td class="xl81" style="border-left: medium none;">0</td> <td class="xl76">0</td> <td class="xl82" style="font-size: 10pt; color: rgb(51, 153, 102); font-weight: 400; text-decoration: none; font-family: Arial; border-width: medium 0.5pt medium medium; border-style: none solid none none; border-color: -moz-use-text-color windowtext -moz-use-text-color -moz-use-text-color;">0</td> </tr> <tr style="height: 12.75pt;" height="17"> <td class="xl83" style="height: 12.75pt;" height="17">secondary conversion</td> <td class="xl72">50.0%</td> <td class="xl70">50.0%</td> <td class="xl71" style="font-size: 10pt; color: rgb(51, 153, 102); font-weight: 400; text-decoration: none; font-family: Arial; border-width: medium 0.5pt 0.5pt medium; border-style: none solid solid none; border-color: -moz-use-text-color windowtext windowtext -moz-use-text-color;">0.0%</td> <td class="xl72" style="border-left: medium none;">50.0%</td> <td class="xl70">50.0%</td> <td class="xl71" style="font-size: 10pt; color: rgb(51, 153, 102); font-weight: 400; text-decoration: none; font-family: Arial; border-width: medium 0.5pt 0.5pt medium; border-style: none solid solid none; border-color: -moz-use-text-color windowtext windowtext -moz-use-text-color;">0.0%</td> <td class="xl72" style="border-left: medium none;">50.0%</td> <td class="xl70">50.0%</td> <td class="xl71" style="font-size: 10pt; color: rgb(51, 153, 102); font-weight: 400; text-decoration: none; font-family: Arial; border-width: medium 0.5pt 0.5pt medium; border-style: none solid solid none; border-color: -moz-use-text-color windowtext windowtext -moz-use-text-color;">0.0%</td> <td class="xl72" style="border-left: medium none;">50.0%</td> <td class="xl70">50.0%</td> <td class="xl71" style="font-size: 10pt; color: rgb(51, 153, 102); font-weight: 400; text-decoration: none; font-family: Arial; border-width: medium 0.5pt 0.5pt medium; border-style: none solid solid none; border-color: -moz-use-text-color windowtext windowtext -moz-use-text-color;">0.0%</td> <td class="xl72" style="border-left: medium none;">50.0%</td> <td class="xl70">50.0%</td> <td class="xl71" style="font-size: 10pt; color: rgb(51, 153, 102); font-weight: 400; text-decoration: none; font-family: Arial; border-width: medium 0.5pt 0.5pt medium; border-style: none solid solid none; border-color: -moz-use-text-color windowtext windowtext -moz-use-text-color;">0.0%</td> <td class="xl72" style="border-left: medium none;">50.0%</td> <td class="xl70">50.0%</td> <td class="xl71" style="font-size: 10pt; color: rgb(51, 153, 102); font-weight: 400; text-decoration: none; font-family: Arial; border-width: medium 0.5pt 0.5pt medium; border-style: none solid solid none; border-color: -moz-use-text-color windowtext windowtext -moz-use-text-color;">0.0%</td> <td class="xl72" style="border-left: medium none;">50.0%</td> <td class="xl70">50.0%</td> <td class="xl71" style="font-size: 10pt; color: rgb(51, 153, 102); font-weight: 400; text-decoration: none; font-family: Arial; border-width: medium 0.5pt 0.5pt medium; border-style: none solid solid none; border-color: -moz-use-text-color windowtext windowtext -moz-use-text-color;">0.0%</td> <td class="xl72" style="border-left: medium none;"> </td> <td class="xl72"> </td> <td class="xl71" style="font-size: 10pt; color: rgb(51, 153, 102); font-weight: 400; text-decoration: none; font-family: Arial; border-width: medium 0.5pt 0.5pt medium; border-style: none solid solid none; border-color: -moz-use-text-color windowtext windowtext -moz-use-text-color;"> </td> </tr> <tr style="height: 12.75pt;" height="17"> <td class="xl73" style="height: 12.75pt;" height="17"> </td> <td class="xl73"> </td> <td class="xl74" style="border-top: medium none;"> </td> <td class="xl73"> </td> <td class="xl73"> </td> <td class="xl74" style="border-top: medium none;"> </td> <td class="xl73"> </td> <td class="xl73"> </td> <td class="xl74" style="border-top: medium none;"> </td> <td class="xl73"> </td> <td class="xl73"> </td> <td class="xl74" style="border-top: medium none;"> </td> <td class="xl73"> </td> <td class="xl73"> </td> <td class="xl74" style="border-top: medium none;"> </td> <td class="xl73"> </td> <td class="xl73"> </td> <td class="xl73"> </td> <td class="xl73"> </td> <td class="xl73"> </td> <td class="xl73"> </td> <td class="xl73"> </td> <td class="xl73"> </td> <td class="xl73"> </td> <td class="xl73"> </td> </tr> </tbody></table>What I want to occur is for the YTD data to not disappear after each fiscal year has ended (our new year starts in July). Right now, the YTD data stays visible and adds properly until the end of June. However, June's data isn't available to add in until the middle of July, by which point the YTD is showing blank data, which is not what I want to happen. Only 1 year's data is added onto a sheet at a time, so how do I get the data to stay visible on the YTD area? Is it possible to add the year into the equation somehow?

Thank you!