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.
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.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks