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!

"Fred Smith" wrote:

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.

"jakesmom" wrote in message
...
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.