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

ExcelBanter (https://www.excelbanter.com/)

- Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)

- - Can I write "=AVERAGE(B51:B65005)" (https://www.excelbanter.com/excel-worksheet-functions/163209-can-i-write-%3Daverage-b51-b65005.html)

Daniel

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

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

Gary''s Student

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

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

All times are GMT +1. The time now is 03:18 AM.