Hi Daniel:

We don't need to know where the last cell is !!

=AVERAGE(A50:A65536) is o.k. because AVERAGE ignores all the blank cells
below the last used cell.
--
Gary''s Student - gsnu200745


"Daniel" wrote:

How can I calculate a function for a certain range such as
Range from cell 50 to the last cell
I tried this but not work

Average(A50:A)

Need your help
Daniel