I got a sumif formula, where I sum the hours if a certain person is represented.
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!