Excel Excel Formula OFFSET maybe?

Joined
Feb 8, 2016
Messages
2
Reaction score
0
I have a very big spreadsheet with 12 worksheets (one for each month) and one Year To Date worksheet. On the YTD worksheet I would like to add just the totals from the other 12 worksheets. The totals are all 8 rows apart starting in cell D10 going through D1066.

I would like to have my formula automatically advance by 8. Example: D10 would be the constant in the first formula. D18 would be constant in the next, D26 in the next and so on.

How do I tell the formula that I want to advance by 8 not by 1

Thanks,
CJ
 
Joined
Feb 8, 2016
Messages
2
Reaction score
0
I should have clarified that I want it to advance by 8 "rows" not just by the number 8.
Example:
First formula is =SUM(Jan!D10+Feb!D10+Mar!D10)
Next formula is =SUM(Jan!D18+Feb!D18+Mar!D18)
nets would be D26 and so on.

Is there a way to drag this formula yet have it advance by 8 rows instead of 1 row?
 

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