View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Daniel Daniel is offline
external usenet poster
 
Posts: 354
Default 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