Try this:

=SUM(OFFSET(A2001,COUNT(A2001:A65536)-1,,-25))

Or, use a cell to hold the number criteria:

B1 = 25

=SUM(OFFSET(A2001,COUNT(A2001:A65536)-1,,-B1))

Biff

"gotta know" wrote in message
ups.com...
Now, I am wondering if this is possible...

1. My formula gives me two values - either 0 or 1.

2. I input data daily in column A

3. I need a sum of the "trailing" 25 periods

4. My cells look like this:

a2001 1
a2002 1
a2003 0
a2004 0
a2005 0
a2006 0
a2007 1
...
a4999 1
a5000 1
etc.

5. Of course, I could create a formula adjacent to the cell, b5000=
sum(a4076:a5000), but I would like to have that same result listed on
cell A1 for the previous 25 periods (for quick reference/summary page).
Is that possible?

-E