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