How do I create a formula that will select the last 20 entries in a column of
a database?
How do I create a formula that will select the last 20 entries in a column of
a database?
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 [email protected]> wrote in message
news:[email protected]...
> How do I create a formula that will select the last 20 entries in a column
of
> a database?
You can avoid the Volatile OFFSET function.
Try,
=SUM(INDEX(A:A,COUNTA(A:A)-19):INDEX(A:A,COUNTA(A:A)))
HTH
Kris
Yeah, 5 functions for 3. Can't see much rationale in that.
--
HTH
RP
(remove nothere from the email address if mailing direct)
"Krishnakumar" <[email protected]>
wrote in message
news:[email protected]...
>
> 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
>
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks