Share via

Formula in Excel

Anonymous
2018-01-12T19:47:27+00:00

For this equation, is there a simpler way to do it so that I can just say D:R with the specific cells I want to multiply.

=(D10*D9*D7)+(E10*E9*E7)+(F10*F9*F7)+(G10*G9*G7)+(H10*H9*H7)+(I10*I9*I7)+(J10*J9*J7)+(K10*K9*K7)+(L10*L9*L7)+(M10*M9*M7)+(N10*N9*N7)+(O10*O9*O7)+(P10*P9*P7)+(Q10*Q9*Q7)+(R10*R9*R7)

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
2018-01-12T21:24:44+00:00

This should do what you want:

=SUMPRODUCT(D7:R7,D9:R9,D10:R10)

Was this answer helpful?

1 person found this answer helpful.
0 comments

4 additional answers

Sort by: Most helpful
Most helpful Newest Oldest
  1. Anonymous
    2018-01-12T21:32:44+00:00

    Lifesaver!! Thank you!

    Was this answer helpful?

    0 comments
  2. Anonymous
    2018-01-12T20:04:18+00:00

    Hi,

    That is not possible in Excel.

    Let me know if that helps.

    Kind Regards,

    Engr. Jamshed Muhammad

    Was this answer helpful?

    0 comments
  3. Anonymous
    2018-01-12T20:01:06+00:00

    When I have a lot of row, that leads to not only a lot of equation to write out but possible errors. There isn't a way to be able to do like the below?

    SUM (D10*D9*D7):(R10*R9*R7)

     Or something like that?

    Was this answer helpful?

    0 comments
  4. Anonymous
    2018-01-12T19:57:24+00:00

    Hi,

    It think that is best way we can dot that.

    Let me know if that helps.

    Kind Regards,

    Engr. Jamshed Muhammad

    Was this answer helpful?

    0 comments