Jun 03 2021 02:55 PM
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.
Jun 03 2021 03:28 PM
@ktp11475
You can use SUMPRODUCT:
=SUMPRODUCT(C2:C6,F2:F6)