Correction...

=MIN(OFFSET(Sheet1!B1,MAX(0,COUNTA(Sheet1!B:B)-60),0,60,1))

In article <domenic22-D9B9D0.08515701062005@msnews.microsoft.com>,
Domenic <domenic22@sympatico.ca> wrote:

> For the last numerical value...
>
> =LOOKUP(9.99999999999999E+307,Sheet1!B:B)
>
> For the minimum value for the last 60 entries, provided there are no
> blanks within your range...
>
> =MIN(OFFSET(Sheet1!B1,MAX(0,COUNTA(Sheet1!B:B))-60,0,60,1))
>
> For the maximum and average, replace MIN() accordingly.
>
> Hope this helps!