It seems that you would simply have to evaluate all data directly from the
source in this final cell. I'm assuming that you can't simply average those
monthly percentages, because I'm assuming that the dataset changes from
month to month, so one month's percentage may be based on much larger
numbers than another, and an average of the percentages woudn't take that
into account.

So therefore, you need to use whatever method you are already using to get
your individual month percentages, but without limiting it to a specific
month.

"jakesmom" wrote in message
...
I have a sheet where cell A2 is a January percentage, cell B2 is a February
pecentage, C2 is a March percentage, etc. I would like the final cell to
have a formula which will calculate the rolling year to date percentage of
each month.