#### JoshuaMars

##### New Member

- Joined
- Jul 13, 2006

- Messages
- 46

C5 down to C14 is the same formula =INDEX(DAILY!C:C,ROW()+0)+INDEX(DAILY!C:C,ROW()+11)+INDEX(DAILY!C:C,ROW()+22)+INDEX(DAILY!C:C,ROW()+33)+INDEX(DAILY!C:C,ROW()+44)+INDEX(DAILY!C:C,ROW()+55)+INDEX(DAILY!C:C,ROW()+66)

the above formula goes up in 11

then the next row does a sum of C5 to C14

=SUM(C5:C14)

C16 down to C25 is the same formula =INDEX(DAILY!C:C,ROW()+66)+INDEX(DAILY!C:C,ROW()+77)+INDEX(DAILY!C:C,ROW()+88)+INDEX(DAILY!C:C,ROW()+99)+INDEX(DAILY!C:C,ROW()+110)+INDEX(DAILY!C:C,ROW()+121)+INDEX(DAILY!C:C,ROW()+132)

agian the above formula goes up in 11

then the next row does a sum of C16 to C25

=SUM(C16:C25)

this continues down the page until row 576.

Hope someone can think of something.

Thanks in advance.

Joshua