"Dave Thomas" wrote...
You missed the point entirely. You should have looked at the original
message.
....

I did. The OP's process is flawed if future months contain 0s rather than
are blank. That should be corrected by making those cells contain nothing or
"", which AVERAGE automatically skips.

So what's the correct answer if any of the OP's HISTORICAL months contain
0s?