RD:

Your formula below gave me: "#NUM!"

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

The example below details what I need. Basically, if I have cells
A5:A5000 filled with data, and keep inputting data in A5001, A5002 on a
daily basis, I need the SUM of the trailing 25 periods.

A1 = sum of last 25 values

cell value
a501 1
a502 8
a503 0
....
a1001 0
a1002 0
a1003 6 ( I would need cell A1 to give me the sum of the last 25
periods sum(a978:a1003)



RagDyeR wrote:
Anything wrong with my suggestion?