Need formula to STAY

[Needs Help]

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.

 

[Don Guillett]

$c$5:$n$5

 

[RagDyeR]

Try this:

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

--

HTH,

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

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.

 

[Ron Coderre]

Since you are adding/deleting columns,
try this:

=AVERAGE(INDEX(5:5,3):INDEX(5:5,14))

Does that help?
--------------------------

Regards,

Ron
Microsoft MVP (Excel)
(XL2003, Win XP)

 

[RagDyeR]

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 !
-----------------------------------------------------------------------------------------------

Try this:

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

--

HTH,

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

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.

 

[Needs Help]

This formula did not work for me. When I added a new column it still changed
it to the D5:O5. But I did get it from another user. Thanks for the help.

 

[Needs Help]

This worked!! Thank you so much for your help.

 

[RagDyeR]

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