Using the offset and sum formula

[thedunna]

Good morning all,

I am having difficulty understanding and applying the offset formula to be able to drag down my worksheet. I believe it must be a simple formula. What I am trying to do is take cells H8 and H9 and sum the total then dividing by 2. I need a formula whereby I can then drag down my worksheet and it would jump to H10 and H11, then H12 and H13, then H14 and H15, etc... Can anyone help? Thank you for looking.

[6StringJazzer]

What cells do you want your formulas to go in?

Suppose your formulas start in A1 (or row 1 of any column). The formula would look like

Please Login or Register  to view this content.

[thedunna]

Jeff, thank you. It works perfectly and I believe I understand the calculation.