Thread
:
Need formula to STAY
View Single Post
#
2
Posted to microsoft.public.excel.worksheet.functions
Don Guillett
external usenet poster
Posts: 10,124
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.
Reply With Quote
Don Guillett
View Public Profile
Find all posts by Don Guillett