Thank you all for your help. Arvi hit it on the $... works well,
simple forumula, didn't have to arrange anything. Wow, 2 days worth of
headbanging for what seems a simple forumula.

I wonder why excel doesn't have a simple formula for what many must
use?:

=sum("last data in column",-25) or something...

Thank you again.

-EG

Arvi Laanemets wrote:
Hi

With some header text (like 'Data' or 'Values' in A1, and 1s or 0s in column
as starting from A2 without any gaps in datarange, enter into any cell the
formula
=SUM(OFFSET($A$1,MAX(COUNTA($A:$A)-25,1),,MIN(25,COUNTA($A:$A)),))


Arvi Laanemets



"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