Sumproduct with fixed columns

[ck_1357]

Hi!

Im new to excel and hopes that someone can help me with a problem regarding the sumproduct function.

I have three columns in my sheet1, column A and column B contain 1000 numbers.

Hence, column A goes from A1 to A1000 and column B from B1 to B1000.

In the first row of column C, i want to use sumproduct on A1:A5 with B1:B5.

My problem arises when I want to drag the formula down, in the second row of column C I want

to use sumproduct on A6:A10 with B6:B10 but the formula uses A2:A6 with B2:B6.

Is there a way to fix the ranges when I am using sumprodct so it takes "fixed" ranges like every fifth,

A1:A5 with B1:B5 , A6:A10 with B6:B10, A11:A15 with B11:B15 and so on.

Thanks a lot.

 

[West Man]

Perhaps better solutions, but for your ranges try (example for A):

INDIRECT("A"&((ROW()-1)*5)+1&":A"&((ROW()-1)*5)+5)

 

[ck_1357]

Thank you very much