Paste Consistently Occuring Rows

[Brandon G.]

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

 

[ryguy7272]

Try this; it sums every five rows:
=SUM(IF(MOD(ROW($A$1:$A$16),B1)=0,$A$1:$A$16,0))

Assumption is that data is in ColA and the number 7 is in CellB1.

Regards,
Ryan---