You're welcome, and thanks for the feed-back.
--

Regards,

RD
-----------------------------------------------------------------------------------------------
Please keep all correspondence within the Group, so all may benefit !
-----------------------------------------------------------------------------------------------

"Needs Help" wrote in message
...
This worked!! Thank you so much for your help.

"RagDyeR" wrote:

And of course ... again ... don't need the absolutes:

=AVERAGE(INDIRECT("C5:N5"))

--

Regards,

RD
-----------------------------------------------------------------------------------------------
Please keep all correspondence within the Group, so all may benefit !
-----------------------------------------------------------------------------------------------

"RagDyeR" wrote in message
...
Try this:

=AVERAGE(INDIRECT("$C$5:$N$5"))

--

HTH,

RD
================================================== ===
Please keep all correspondence within the Group, so all may benefit!
================================================== ===

"Needs Help" wrote in message
...
I have a formula in P5 that states =Average(C5:N5).

Monthly I need to add a new column C and delete column O.

How do I get the formula to stay C5:N5? It changes to D5:O5.