software

I would like to multiply c5*4, d5*9, e5*4 and then add these all in single
formula in cell f5. Can this be done? Thanks for any help
quot;Frank Malonequot; gt; wrote in message
...
gt;I would like to multiply c5*4, d5*9, e5*4 and then add these all in single
gt;formula in cell f5. Can this be done? Thanks for any help

F5 =C5*4 D5*9 E5*4

Bruno
Hi Frank,

another solution:

Enter into cell F5:

=SUMPRODUCT(C5:E5,{4,9,4})

HTH,
BerndThanks for the formula works great.

gt; wrote in message ups.com...
gt; Hi Frank,
gt;
gt; another solution:
gt;
gt; Enter into cell F5:
gt;
gt; =SUMPRODUCT(C5:E5,{4,9,4})
gt;
gt; HTH,
gt; Bernd
gt;
Thanks for the formula works great.

quot;Bruno Campaniniquot; gt; wrote in message
...
gt; quot;Frank Malonequot; gt; wrote in message
gt; ...
gt;gt;I would like to multiply c5*4, d5*9, e5*4 and then add these all in single
gt;gt;formula in cell f5. Can this be done? Thanks for any help
gt;
gt; F5 =C5*4 D5*9 E5*4
gt;
gt; Bruno
gt;
type in f5
sum(c5*4,d5*9,e5*4)