|
Need formula to STAY
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. |
Need formula to STAY
$c$5:$n$5
-- Don Guillett Microsoft MVP Excel SalesAid Software "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. |
Need formula to STAY
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. |
Need formula to STAY
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) "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. |
Need formula to STAY
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. |
Need formula to STAY
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. "Don Guillett" wrote: $c$5:$n$5 -- Don Guillett Microsoft MVP Excel SalesAid Software "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. |
Need formula to STAY
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. |
Need formula to STAY
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. |
| All times are GMT +1. The time now is 06:56 AM. |
Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com