Rolling Year-to-Date Percentages

[jakesmom]

I have a sheet where cell A2 is a percentage for January, B2 is a percentage
for February, C2 is a percentage for March, etc. I would like the last cell
to have a formula which calculates the rolling year-to-date percentage total.

 

[Fred Smith]

What's a rolling year to date percentage? Is it a sum, an average, or
something else? Where is the "last cell"?

As long as the cells for future months are blank, you can get away with
using =Sum(...) or =Average(...) for the entire range and they will ignore
blank cells.

Hope this helps,
Fred.

 

[Shane Devenshire]

HI,

We need to know what your data looks like. Remember that year to date
percent is not the sum or average of the monthly percentages. To get the ytd
figures you need to use the source data.

 

[jakesmom]

Thank you so much for your quick response. It is the average of the 12
months and I guess I was getting a mental block about having the empty cells.
I put in the formula and it seems to be working great. So simple....thanks
for clearing the fog away!