Adding Columns with Multipliers

[Jacky D.]

I have a very large spreadsheet with columns going to DE. I would like to
create a sum formula on say column DF which would take the number enetered on
say call A4 and multiply it against cell A1

It would look like this
a b c ................. DF
1 2.5 5.0 9 (Multiplier Row)
2 4 8 2 (Data Row)
=SUM(a2*a1)+(b2*b1)+(c2*c1)..(de2*de1)
3 2 4 9
=SUM(a3*a1)+(b3*b1)+(c3*c1)..(de3*de1)
Since I have soo many colmns, is there an easier way of doing this aside
from picking each cell and typing in the functions. And oh yeah, I'm using
Excel 2000 : (

Any help would be apppreciated, I can't change the sheets, they're used by
other departments, or I would have this set up differently.

 

[Elkar]

Use the SUMPRODUCT function. Like this:

=SUMPRODUCT($A$1:$DE$1,A2E2)

Copy down as needed.

HTH
Elkar

 

[T. Valko]

Try this:

=SUMPRODUCT(A$1E$1,A2E2)

Copy down as needed

 

[Jacky D.]

Thank you both so much for the help, I knew there had to be ab easier way to
do this!

You've made tomorrow a much easier day for me, Thanks again : )

 

[T. Valko]

You're welcome. Thanks for the feedback!