This will get the last value entered in column A

=INDEX(A:A,MATCH(9.99999999999999E+307,A:A))

This will get the ROW # of the last entry in Col A.

=MATCH(9.99999999999999E+307,A:A)

This will sum the last 60 entries in a column - assuming a header in row 1
and no blank cells

=SUM(OFFSET(A2,MAX(0,COUNTA(A2:A65536)-60),0,60,1))

& so will this

=SUM(OFFSET(INDIRECT("A"&MATCH(9.99999999999999E+3 07,A:A)-60),0,0,60,1))


"ghostrider" wrote:

Hey all. Here is my dilemma. On sheet 1 column B i currently have 64
numerical entries to which i am adding 1 entry each day. On sheet 2 i am
trying to do the following things. First i want one cell to automatically
display the last entry i have made. Secondly, i am trying to do min max and
averages for the last 60 entries.

I know that you need to use some combination of the count function within
the offset function but cant seem to get it right. I am uncertain of what i
should be using for the reference, rows, columns, height width parts. Any
suggestions???

Thanks much.