Bob,

> =SUMPRODUCT(--(MOD(A1:A25,25)<>1),A1:A25)


Didn't you left some ROW()s out there! ;-)

=SUMPRODUCT(--(MOD(ROW(A1:A25),25)<>1),A1:A25)

Regards,

Daniel M.