B
BadBoy
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 the 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
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 the 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