Is there another function instead of this....

[Faio]

I've been looking for my previous message that I posted and never seen it so
I am posting it again

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

 

[Andy Brown]

is there another simple or shorter formula/function to use rather than
this?

=SUM($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
)

is marginally shorter

I'm no maths wiz, but

=SUMPRODUCT($A$1:$I$1,A2:I2)

may fit the bill.

HTH,
Andy

 

[Arvi Laanemets]

Hi

=SUMPRODUCT($A$1:$I$1,$A2:$I2)

 

[Ron Rosenfeld]

I've been looking for my previous message that I posted and never seen it so
I am posting it again

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

=SUMPRODUCT($A$1:$I$1,A2:I2)


--ron