Thread
:
Sum every 10th cell in a range of cells?
View Single Post
#
7
Ron Coderre
Posts: n/a
Try something like this:
=SUMPRODUCT(--(MOD(ROW($A$10:$A$30)-ROW($B$10),10)=0)*$A$10:$A$30)
--
Regards,
Ron
Reply With Quote