How can I copy a formula to new rows so that some values remain constant?

I have used the following long but simple formula.

=SUM((B17*B14)+(C17*C14)+(D17*D14)+(E17*E14)+(F17*F14)+(G17*G14)+(H17*H14)+(I17*I14)+(J17*J14)+(K17*K14)+(L17*L14)+(M17*M14)+(N17*N14)+(O17*O14))

I need to copy it to numerous other cells. However I need the row fourteen values to remain the same while the other values change according to which row I'm copying it to e.g

=SUM((B20*B14)+(C20*C14)+(D20*D14)+(E20*E14)+(F20*F14)+(G20*G14)+(H20*H14)+(I20*I14)+(J20*J14)+(K20*K14)+(L20*L14)+(M20*M14)+(N20*N14)+(O20*O14))

Is there any way of doing this without changing the formula manually every time?

Try:

=$B$14*SUM(B20:O20)

btw, the original formula could be simplified to:

=Sumproduct(B17:O17,B14:O14)

Edit: I am pretty sure that the original thread was trying to multiply each element by B14... that is reason for first formula given here... OP must have edited the question....

Hey NBVC, I just read your reply. Doh! I just wasted two and a half hours.

Thank you very much indeed.