Use a dynamic range
http://www.contextures.com/xlNames01.html#Dynamic
=AVERAGE(MyRange)
--
Regards,
Peo Sjoblom
Portland, Oregon
"murphyslaw18" wrote in message
...
How does someone write, lets say an average function to constantly update
from a column that has no definite end? Currently I am using:
=AVERAGE(J5:J35)
but this will have to constantly be changed as the J column is filled out.