Can I write "=AVERAGE(B51:B65005)"

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Daniel - 23 Oct 2007 18:17 GMT

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

Reply to this Message

Gary''s Student - 23 Oct 2007 18:38 GMT

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

=AVERAGE(B51:B65536)

Signature

Gary''s Student - gsnu200750

> Hi
> 1. I want average from cell B 51 to the last cell of column B. can I write
[quoted text clipped - 4 lines]
> Thanks
> Daniel

Reply to this Message