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.
Download File
You’d like to try it yourself? Download the FREE file here. Let me know what you come up with!
Leila Gharani
I’ve spent over 20 years helping businesses use data to improve their results. I've worked as an economist and a consultant. I spent 12 years in corporate roles across finance, operations, and IT—managing SAP and Oracle projects.
As a 7-time Microsoft MVP, I have deep knowledge of tools like Excel and Power BI.
I love making complex tech topics easy to understand. There’s nothing better than helping someone realize they can do it themselves. I’m always learning new things too and finding better ways to help others succeed.
