ANother formula to use instead of +

[Faio]

Could anyone suggest another way to do this calculation

E.g

Under columns A,B,C,D,E,F,G, H, I entered, $100, $50, $20, $10, $5, $2, $1,
0.50, 0.20 respectively in row 1.
In row two I have numbers underneath those numbers above such as,
3,2,3,2,1,4,6,7,7.

The formula I used CELL J2 is something like this
=(($A$1*A2)+($B$1*B2)+($C$1*C2)+($D$1*D2)+($E$1*E2)+($F$1*F2)+($G$1*G2)+($H$
1*H2)+($I$1*I2)). When I copy this formula down it works very well but is
there another simple or shorter formula/function to use rather than this?

Thanks

 

[Frank Kabel]

Hi
=SUMPRODUCT($A$1:$H$1,A2:H2)