brodskyfuCopper ContributorOct 09, 2024SolvedWhy SUM doesn't work out with dynamic array? As above Show MoreHarun24HROct 09, 2024brodskyfu 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#)
Harun24HROct 09, 2024brodskyfu 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#)
Harun24HROct 09, 2024brodskyfu 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#)
