Share via

SUM(PRODUCT()) Formula

Anonymous
2020-07-06T19:53:44+00:00

I have a simple formula need:

Multiply K11* L11 then add M11.

I have tried:

=SUM(PRODUCT(K11:L11):M11)

=SUM((K11 * L11):M11)

As a former programmer, I know the logic works, but the D+*m software won't accept it. "There is a problem with this formula."

TIA,

Roy

Microsoft 365 and Office | Excel | For home | Windows

Locked Question. This question was migrated from the Microsoft Support Community. You can vote on whether it's helpful, but you can't add comments or replies or follow the question.

0 comments

Answer accepted by question author

Anonymous
2020-07-06T20:01:12+00:00

If your formulas use a comma for a list separator character try,

=SUM(K11 * L11, M11)

=SUM(PRODUCT(K11:L11), M11)

'simpler as,

=K11*L11+M11   'mathematical hierarchy rules apply

If your computer uses a semi-colon then,

=SUM(K11 * L11; M11)

=SUM(PRODUCT(K11:L11); M11)

Was this answer helpful?

1 person found this answer helpful.
0 comments

1 additional answer

Sort by: Most helpful
Most helpful Newest Oldest
  1. Anonymous
    2020-07-06T20:29:45+00:00

    Thank you!

    Coma works, Semi does not.

    Simplified works too.

    Again, thanks.

    Was this answer helpful?

    0 comments