starting a formula from the next cell on from the previous formula

  • Hi Folks

    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.



Participate now!

Don’t have an account yet? Register yourself now and be a part of our community!