I may be trying to make this more complex than it really is but....
If I have a formula in a cell that says: =SUM(EJ4:EN4) is there a way to make the formula in the next cell go =SUM(EO4:ES4) ??
However, if I just drag the formula across it always starts with the next cell on from the first cell in the previous formula; i.e =SUM(EK4:EO4)
Hoping someone can help.