Move two cells down when copying a formula

    Hi!


    I got a sumif formula, where I sum the hours if a certain person is represented.
    =SUMIF(K12:R12;"TW";K11:R11)
    Hours in row 11 and the person in row 12.


    The patern in my excel document is that every second row is hours and persons. Hours on odd row number and persons on even.


    My problem is that when I want to copy my formula down, it goes one row down to =SUMIF(K13:R13;"TW";K12:R12)
    I want it to go two rows down to =SUMIF(K14:R14;"TW";K13:R13)


    Does anyone know of a way to fix this?


    Thanks in advance!

    Re: Move two cells down when copying a formula


    Try:


    =SUMIF(INDEX(K:R,2*(ROWS($K$1:K1)-1)+12,0),"TW",INDEX(K:R,2*(ROWS($K$1:K1)-1)+11,0))


    copied down

    Where there is a will there are many ways. Finding one that works for you is the challenge!

Participate now!

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

Register Yourself Login