A question of Excel formula

Copper Contributor

If I want set a formula in C14 and the result is $1,145. (C2*F2+C3*F3+C4*F4+C5*F5+C6*F6) What is the formula? 

Have someone can help me?

 

Thx.

 

Stock List.jpg

1 Reply

@ktp11475 

You can use SUMPRODUCT:

 

=SUMPRODUCT(C2:C6,F2:F6)