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.