Quick absolute reference question

[zincyo]

I have a column in which the first cell has the following equation: =B6*SUMPRODUCT($B$6:$F$6,B11:F11)

Using dynamic ranges, I made the range B6:F6 "weight".

Therefore, the first cell in my column is now: =B6*SUMPRODUCT(weight,B11:F11).

This first cell is located at B17. What I want to do is get cell C17 to be equal to =B6*SUMPRODUCT(weight,B12:F12). Therefore, I use the absolute reference technique, and I make the equation in cell B17 equal to: =B6*SUMPRODUCT(weight,$B11:$F11), as I want B and F to remain the same, but I want the 11 to become 12, and in the next cell the 12 to become 13, etc.

If I were to use this equation to go DOWN a row, it works, however when I try to apply it to go across my column, the $B11:$F11 remains exactly the same.

I'm sure this is a VERY easy fix, i'm just now sure what I am doing incorrectly. Thanks!!

[daddylonglegs]

You can't do that by adjusting the $ signs - one way is to use OFFSET, e.g. try this formula in B17 copied across

=B6*SUMPRODUCT(weight,OFFSET($B11:$F11,COLUMNS($B17:B17)-1,))