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.

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.

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.

--
If this helps, please click the Yes button

Cheers,
Shane Devenshire


"jakesmom" wrote:

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.

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.