| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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. |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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. |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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. |
|
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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. |
|
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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. |
|
#6
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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. |
|
#7
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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. |
|
#8
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Formula and values stay with row/cell after sort | Excel Worksheet Functions | |||
| how to get a formula to stay as 0 | Excel Discussion (Misc queries) | |||
| formula to stay fixed on two columns as you add more columns | Excel Discussion (Misc queries) | |||
| How do I get my formula to stay the same | New Users to Excel | |||
| Autofit does not stay on. | Excel Discussion (Misc queries) | |||
Linear Mode
