Paste Consistently Occuring Rows

B

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
 
R

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

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top