Traveltime
New Member
- Joined
- May 21, 2018
- Messages
- 17
I've done a lot of searching for a solution without any luck. The search criteria I'm using must be wrong because I think this may be fairly common.
The formula in cell N2 needs to be copied down about 80 rows, but the range that needs to be summed on each row needs to begin +67 cells from the end of the sum cell location.
Formula I need:
N2 formula is: E2=sum(other worksheet e1:e3) then drag the formula to N3.
N3 formula needs t be is: N2=sum(other worksheet e70:e72)
Of course when I drag the formula I get this in the N3 cell
N2=sum(e2:e4)
I'm fairly certain there is a way toad 67 to the last cell and start the sum at the correct cell location, but I don't know how. Would someone be kind enough to assist?
TIA
The formula in cell N2 needs to be copied down about 80 rows, but the range that needs to be summed on each row needs to begin +67 cells from the end of the sum cell location.
Formula I need:
N2 formula is: E2=sum(other worksheet e1:e3) then drag the formula to N3.
N3 formula needs t be is: N2=sum(other worksheet e70:e72)
Of course when I drag the formula I get this in the N3 cell
N2=sum(e2:e4)
I'm fairly certain there is a way toad 67 to the last cell and start the sum at the correct cell location, but I don't know how. Would someone be kind enough to assist?
TIA