Anything wrong with my suggestion?
--

Regards,

RD
-----------------------------------------------------------------------------------------------
Please keep all correspondence within the Group, so all may benefit !
-----------------------------------------------------------------------------------------------

"gotta know" wrote in message
ups.com...
*EDIT...

Yes it does give me a circular reference. I moved to column B.

This forumula gives me the sum of values in A2:A20, not the last 25
periods in column A.

=SUM(LARGE(A2:A20,ROW(INDIRECT("1:"&MIN(COUNT(A:A) ,25)))))