Forum Discussion
Why SUM doesn't work out with dynamic array?
As above
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#)
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~
