Range of a function

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

Guest

How can I calculate a function for a certain range such as
Range from cell 50 to the last cell
I tried this but not work

Average(A50:A)

Need your help
Daniel
 
Hi Daniel:

We don't need to know where the last cell is !!

=AVERAGE(A50:A65536) is o.k. because AVERAGE ignores all the blank cells
below the last used cell.
 
Hi Daniel,

You can use a named range and call it Range1 or whatever
then the formula would be =AVERAGE(Range1)

To name a range just select the range of cells
then click in the Name Box and type the name and hit enter
The Name box is just to the left of the formula bar
it usually displays the address of the active cell.
See Help for more details.

HTH
Martin
 
Back
Top