Thread: Eliminating every 25th row
View Single Post
  #5   Report Post  
Daniel.M
 
Posts: n/a
Default Eliminating every 25th row
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.


Reply With QuoteReply With Quote