Value Return with the offset(?) function

[Diane]

I have a spreadsheet that has (for example) the following
values

A5 = 5
A10 = 18
A15 = 7
A20 = 22

Basically these numbers are summing other parts in the
spreadsheet (weekly numbers). They are every 5 rows.
Each week I add a new row (this week the value will be
placed in A25, the week after, a30 etc etc. I would like
to have a referenced cell (say in B1) that will give me
the bottom most value, this week it should return what's
in cell A20, next week A25 and so on. I tried using the
Offset function with Count, but for the life of me cannot
do it - if it can be done at all >:-( Any help would be
greatly appreciated

 

[Diane]

Disregard - I had a moment of clarity! Thansk for making
me think!

FYI:
=OFFSET(A$1,(COUNT(A$1:A$5000)*5)-1,,-1)

 

[Domenic]

I would like
to have a referenced cell (say in B1) that will give me
the bottom most value, this week it should return what's
in cell A20, next week A25 and so on. I tried using the
Offset function with Count, but for the life of me cannot
do it - if it can be done at all >:-( Any help would be
greatly appreciated

Hi Diane,

try:

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