P

#### Pablo

I have a year to date spreadsheet that compares data from multiple

years. The prior years have a full years worth of data listed by month

and a row that calculates the YTD. Every month I change the formula in

the YTD row to calculate the correct number of months. Jan-Dec are in

B1-B12 YTD is in B13 so I have formula =sum(B1:B3) for YTD through

March. I have to do this in several rows and prefer sheets that I

don't have to change, thus mess up at some point...

I have another cell that counts the number of values in the current

year and returns a number. So for March 2011, it will look at all the

months for 2011 and only see three values and return 3. In December it

will return 12. Let's say its in C1.

I would like to make the YTD formula select the number of

cells(months) it will sum based on the month counter value. So it

would be something like =sum(B1:B1+value of C1)