View Single Post
  #8   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Ron Coderre Ron Coderre is offline
external usenet poster
 
Posts: 2,118
Default 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.