copying formulas from column to column

[mufan]

Hi,
In the attached spreadsheet, I am trying to drag the formula from one column to the next but I need the same cells to be used in every column with the exception of one cell. For instance, the formula I want to use is in the cell highlighted yellow. In the next cell over (highlighted blue) I want the formula to use the same D and E cells with the only change being the first part of each (G). Both the blue and yellow cell represent what I want to do. For example, the next column (H) would have (H4+D4+E4) in the first part. Column I would have (I4+D4+E4), and so on.

The D and E columns will be in every equation for each column. The problem is that excel wants to use the next column over instead of keeping D and E in each. How do I drag these equations so that it just changes the first part and keeps the D and E columns the same?

[JBeaucaire]

Put this in F11 and copy it across:

=SUMPRODUCT($D$4:$D$10 * $E$4:$E$10 * F4:F10)

[Paul]

Hi Mufan,

To keep the D's and E's static, put a dollar sign in front of them, e.g.

=(F4*$D4*$E4)+(F5*$D5*$E5)+...

If you put a $ next to a column letter, it will stay static. Also, if you put a $ next to a row number it will stay static. (If you put a $ next to both, that cell reference will remain static.)

Hope that helps!