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.


    Cheers


    DezB

Participate now!

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