View Single Post
  #6   Report Post  
Bob Phillips
 
Posts: n/a
Default Eliminating every 25th row

I think I just might have :-))

Bob


"Daniel.M" wrote in message
...
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.