View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
badboy badboy is offline
external usenet poster
 
Posts: 45
Default Adding Progressive Months Totals

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