Adding Regressive Months Totals
 

Hello once again,

From the post shown below, this formula was created by Jacob Skaria of this
forum.

=SUM(INDIRECT("B5:" &
CELL("address",OFFSET(B5,0,MATCH(MONTH(TODAY()),MO NTH(B3:M3),0)-2))))

Can this formula be changed to give me the projected totals for the
remaining months each time it calculates the prvious months?

eg. Sep to Mar 2010 than next month Oct to Mar 2010 then the following month
Nov to March 2010 and so on?

Thanks once again!


Row 3 Column B Apr-09
Row 5 Column B 17,293
Row 3 Column C May-09
Row 5 Column c 16,849
Row 3 Column D Jun-09
Row 5 Column D 17,364
Row 3 Column E Jul-09
Row 5 Column E 24,066
Row 3 Column F Aug-09
Row 5 Column F 17,151
Row 3 Column G Sep-09
Row 5 Column G 17,151
Row 3 Column H Oct-09
Row 5 Column H 17,151
Row 3 Column I Nov-09
Row 5 Column I 16,372
Row 3 Column J Dec-09
Row 5 Column J 17,940
Row 3 Column K Jan-10
Row 5 Column K 16,440
Row 3 Column L Feb-10
Row 5 Column L 15,666
Row 3 Column M Mar-10
Row 5 Column M 28,663

Row 3 Column N Year To Date Totals
Row 5 Column N 92,723

I am looking for a formula to place in Row 5 Column N, that will add the
numbers from all months before our current month (September) starting
with April.
Next month, I wish it to add April through September.
The following month add April through October and so on.
Each month it will add all months before the month we are currently in.

I would be so darn happy if this can be done.

Thank you in advance.

-Bad

Adding Regressive Months Totals
 

Try the below array formula...

=SUM(INDIRECT(CELL("address",OFFSET(B5,0,MATCH(MON TH(TODAY()),MONTH(B3:M3),0)-1)) & ":M5"))

If this post helps click Yes
---------------
Jacob Skaria


"BadBoy" wrote:

Hello once again,

From the post shown below, this formula was created by Jacob Skaria of this
forum.

=SUM(INDIRECT("B5:" &
CELL("address",OFFSET(B5,0,MATCH(MONTH(TODAY()),MO NTH(B3:M3),0)-2))))

Can this formula be changed to give me the projected totals for the
remaining months each time it calculates the prvious months?

eg. Sep to Mar 2010 than next month Oct to Mar 2010 then the following month
Nov to March 2010 and so on?

Thanks once again!


Row 3 Column B Apr-09
Row 5 Column B 17,293
Row 3 Column C May-09
Row 5 Column c 16,849
Row 3 Column D Jun-09
Row 5 Column D 17,364
Row 3 Column E Jul-09
Row 5 Column E 24,066
Row 3 Column F Aug-09
Row 5 Column F 17,151
Row 3 Column G Sep-09
Row 5 Column G 17,151
Row 3 Column H Oct-09
Row 5 Column H 17,151
Row 3 Column I Nov-09
Row 5 Column I 16,372
Row 3 Column J Dec-09
Row 5 Column J 17,940
Row 3 Column K Jan-10
Row 5 Column K 16,440
Row 3 Column L Feb-10
Row 5 Column L 15,666
Row 3 Column M Mar-10
Row 5 Column M 28,663

Row 3 Column N Year To Date Totals
Row 5 Column N 92,723

I am looking for a formula to place in Row 5 Column N, that will add the
numbers from all months before our current month (September) starting
with April.
Next month, I wish it to add April through September.
The following month add April through October and so on.
Each month it will add all months before the month we are currently in.

I would be so darn happy if this can be done.

Thank you in advance.

-Bad

Adding Regressive Months Totals
 

Jacob, you are the bestest!! Thank you sooooooooooooooooooooo much.

"Jacob Skaria" wrote:

Try the below array formula...

=SUM(INDIRECT(CELL("address",OFFSET(B5,0,MATCH(MON TH(TODAY()),MONTH(B3:M3),0)-1)) & ":M5"))

If this post helps click Yes
---------------
Jacob Skaria


"BadBoy" wrote:

Hello once again,

From the post shown below, this formula was created by Jacob Skaria of this
forum.

=SUM(INDIRECT("B5:" &
CELL("address",OFFSET(B5,0,MATCH(MONTH(TODAY()),MO NTH(B3:M3),0)-2))))

Can this formula be changed to give me the projected totals for the
remaining months each time it calculates the prvious months?

eg. Sep to Mar 2010 than next month Oct to Mar 2010 then the following month
Nov to March 2010 and so on?

Thanks once again!


Row 3 Column B Apr-09
Row 5 Column B 17,293
Row 3 Column C May-09
Row 5 Column c 16,849
Row 3 Column D Jun-09
Row 5 Column D 17,364
Row 3 Column E Jul-09
Row 5 Column E 24,066
Row 3 Column F Aug-09
Row 5 Column F 17,151
Row 3 Column G Sep-09
Row 5 Column G 17,151
Row 3 Column H Oct-09
Row 5 Column H 17,151
Row 3 Column I Nov-09
Row 5 Column I 16,372
Row 3 Column J Dec-09
Row 5 Column J 17,940
Row 3 Column K Jan-10
Row 5 Column K 16,440
Row 3 Column L Feb-10
Row 5 Column L 15,666
Row 3 Column M Mar-10
Row 5 Column M 28,663

Row 3 Column N Year To Date Totals
Row 5 Column N 92,723

I am looking for a formula to place in Row 5 Column N, that will add the
numbers from all months before our current month (September) starting
with April.
Next month, I wish it to add April through September.
The following month add April through October and so on.
Each month it will add all months before the month we are currently in.

I would be so darn happy if this can be done.

Thank you in advance.

-Bad