Forum Discussion
Solved
Why SUM doesn't work out with dynamic array?
As above
There is also an old mathematical function that performs precisely the calculation you specified.
MMULT is a very fast function but, despite that, I would more often use the other formula
= MMULT(rowArr, colArr#)
= SUM(TOCOL(rowArr) * colArr#)
- Tks buddy！ Ring a bell in memory~ 🙂
