In Excel: select the last 20 rows of data in a column
 

How do I create a formula that will select the last 20 entries in a column of
a database?

In Excel: select the last 20 rows of data in a column
 

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?

In Excel: select the last 20 rows of data in a column
 

Yeah, 5 functions for 3. Can't see much rationale in that.

--

HTH

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


"Krishnakumar"
wrote in message
news:Krishnakumar.1z1fxa_1132897802.7817@excelforu m-nospam.com...

You can avoid the Volatile OFFSET function.

Try,

=SUM(INDEX(A:A,COUNTA(A:A)-19):INDEX(A:A,COUNTA(A:A)))


HTH


--
Krishnakumar


------------------------------------------------------------------------
Krishnakumar's Profile:
http://www.excelforum.com/member.php...o&userid=20138
View this thread: http://www.excelforum.com/showthread...hreadid=487782