Here is my data example: Assume Period 1 = A1

Period 1
1
2
5
7
Total

Period 2
2
3
4
8
Total

Summary
Total P1
Total P2

How do I tell excel to pull every 7th row into the summary slot
without typing A6 for Total P1 and A13 for Total P2

Thanks in advance

Brandon