Auto Fill Increment Formula

Use a helper column to get your incremental values. In column I, (insert a blank column if needed and then hide, if desired) in cell I12 place a zero, in I13 enter 8. Highlight these two cells and copy down as far as you need. I14 will become 16, I15=24 and so on...

Now, in H12, copy and paste this formula:

=OFFSET(GMS Hours!$L$12,I12,)+OFFSET(Jeremy's Hours!$L$12,I12,)

Because I12 is zero, this will return the sums from L12 on both sheets

Now, copy this formula down as far as needed. H13 will now return the sum of L20 from both sheets, H14 will tally from L28 and so on......


Good Luck

Bruce