Join us June 17–18 for a deep dive into Copilot Control System—live expert-led sessions and Q&A on data security, agent lifecycle, adoption, and more! Learn more >
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#)
