This is the sort of thing

OFFSET($A$1,COUNTA(A:A)-20,0,20,1)

which can be used like so

=SUM(OFFSET($A$1,COUNTA(A:A)-20,0,20,1))

--

HTH

RP
(remove nothere from the email address if mailing direct)


"Tad Blanchard" <Tad wrote in message
...
How do I create a formula that will select the last 20 entries in a column
of
a database?