Excel Summing Sequences?

Question

I'm trying to do sequential summing on a spreadsheet. The first rows are data by date, and I want do sums by the week. but Excel's autopopulate keeps screwing it up and I don't know how to fix that.

Date  A
----
1  |  5
2  |  5
3  |  5
4  |  5
5  |  5
6  |  5
7  |  5
8  |  5 
9  |  5
10 |  5
11 |  5
12 |  5
13 |  5
14 |  5

so what I want in another area

Week  Total
  1 | =sum(A1:A7)
  2 | =sum(A8:A14)
  3 | =sum(A15:A21)
  4 | continue like this for 52 weeks

but what excel keeps giving me with it's auto populating is

Week  Total
  1 | =sum(A1:A7) #The first iteration
  2 | =sum(A2:A8) #auto generated
  3 | =sum(A3:A9) #auto generated

How can I get excel to give me the results I want here? I've been searching on summing for a while and can't seem to even phrase my question right.

Answer 1

=sum(indirect("A"&(row()*7-6)&":A"&(row()*7)))

pasted in row 1 and below should work at least in sheets, it does. (and excel docs say indirect works)