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

    Use sum of OFFSET with arithmetic to calculate the offset ... using COLUMN in the arithmetic to adjust depending on position, etc.

    Cheers, Glenn.


    Beauty is in the eye of the beer-holder.

Participate now!

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

Register Yourself Login