Average balance formula needed please

Good morning,

Usually I am an "advanced" MS Excel user, however I am stumped. If anyone could provide me assistance, it would be greatly appreciated. I am using MS Excel 2000 (yes, my work computer is very old).

What I am looking for is the Q5 average # needed. Is this even possible? What I need is a formula that will incorporate the balance due and break down the "average" number needed monthly.
For example, as of right now, my average would be 11,799.20 because there are 10 months remaining to meet the balance. When I input March's numbers, I would have to change my formula to =SUM(pf/9) ... 9 because there would be 9 months remaining then.

Any clue of a formula that I can use to incorporate the remaining months?

Hopefully what I have listed makes sense.

Thank you!

-FDworkbooksample.xls

Try

=P5/(MAX(1,COUNTBLANK(C5:N5)))

Awesome, that works.

I appreciate it. I've never seen a formula like that and will do some research to see how you figured that out.

Thank you.

You're welcome.