Hello,

I have a formula that I want to be able to drag down by the corner and apply the formula to the next 10 consecutive cells but I want the cells in the formula to move down by 4, not 1.

Ex. I want cell N3=(C4+2*C5+3*C6)/C7 then I drag the corner and apply the formula to the rest of the cells in the column so that N4=(C8+2*C9+3*C10)/C11 , N5=(C12..... and so forth.

I've tried arrays, MOD, Sumproduct, etc. but I'm just not grasping something.

Thanks for your help.