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#)
Harun24HRBronze ContributorOct 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#)
brodskyfuCopper Contributor to Harun24HROct 09, 2024What is the difference in Excel mechanism behind?
SergeiBaklanDiamond Contributor to brodskyfuOct 09, 2024brodskyfu brodskyfuCopper Contributor to SergeiBaklanOct 09, 2024Thanks buddy！
