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

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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
 
Becasue AVERAGE ignores blanks, it is o.k. to use:

=AVERAGE(B51:B65536)
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

countifs Function not giving desired result with date criteria 2
Using names referencing a cell in another workbook 2
Insert Column, Keep Average range 1
Nested IF Statements 6
Average of cells in a column 9
Average every x cells 3
Literal based on Week end 3
Average with specific criteria 7

Back
Top