Sum Non-consecutive Numbers

Originally Posted by ChemistB

Without the indirect (but using Arrayed function, enter with CNTRL SHFT ENTER)

=SUM(IF(INT((ROW($A$1:$A$500)-1)/7)+1=ROW(),$A$1:$A$500,))

Thanks ChemistB. That unfortunately doesn't work though. That formula just added up my entire column.

What I want to do is add A1:A7 and put that value in B1. Then in B2, I want to add A8:14 and so on. Does this make sense?