Forum Discussion

brodskyfu's avatar
brodskyfu
Copper Contributor
Oct 09, 2024
Solved

Why SUM doesn't work out with dynamic array?

As above
excel
  • Harun24HR's avatar
    Harun24HR
    Oct 09, 2024

    brodskyfu You need to transpose first the range Q7:S7 then multiply and sum.

    =SUM(TRANSPOSE(Q7:S7)*R10#)

     SUMPRODUCT() will also work.

    =SUMPRODUCT(TOCOL(Q7:S7),R10#)

     

     

Harun24HR's avatar
Harun24HR
Bronze Contributor
Oct 09, 2024

brodskyfu You need to transpose first the range Q7:S7 then multiply and sum.

=SUM(TRANSPOSE(Q7:S7)*R10#)

 SUMPRODUCT() will also work.

=SUMPRODUCT(TOCOL(Q7:S7),R10#)

 

 

  • brodskyfu's avatar
    brodskyfu
    Copper Contributor
    Oct 09, 2024

    What is the difference in Excel mechanism behind?

  • brodskyfu's avatar
    brodskyfu
    Copper Contributor
    Oct 09, 2024
    I checked the Transpose function, it just looks like that Transpose just rotates the range, but what is the reason behind the difference? I want understand it deeper. Tks~

Resources