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