In the video I explain the basics of the MMULT formula. There is one little rule you need to have in mind when you work with Matrix Multiplication.
MMULT however on it’s own is not enough to give us the answer. We need to use it together with SUMPRODUCT and later with TRANSPOSE and COLUMN functions to get a fully dynamic formula.
Download the Workbook Here.
You’d like to try it yourself? Download the FREE file here. Let me know what you come up with!
I'm a 6x Microsoft MVP with over 15 years of experience implementing and professionals on Management Information Systems of different sizes and nature.
My background is Masters in Economics, Economist, Consultant, Oracle HFM Accounting Systems Expert, SAP BW Project Manager. My passion is teaching, experimenting and sharing. I am also addicted to learning and enjoy taking online courses on a variety of topics.