Thread
:
Eliminating every 25th row
View Single Post
#
6
Bob Phillips
Posts: n/a
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.
Reply With Quote