Paste Consistently Occuring Rows
 

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

Paste Consistently Occuring Rows
 

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---


--
RyGuy


"Brandon G." wrote:

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