Becasue AVERAGE ignores blanks, it is o.k. to use:

=AVERAGE(B51:B65536)
--
Gary''s Student - gsnu200750


"Daniel" wrote:

Hi
1. I want average from cell B 51 to the last cell of column B. can I write
=AVERAGE(B51:B65005)

2. How can I format cell B 51 to the last cell of column B

Thanks
Daniel