I think this is what you had in mind:
=SUM(OFFSET(INDIRECT(ADDRESS(ROW(),COLUMN())),1,0,C1,1))
or "old style":
=SUM(INDEX(A:A,ROW()+1):INDEX(A:A,ROW()+C1))