Tag: array formulas

Running Total Array Formulas Using The MMULT Function

[Editor’s note: This post is from 2017. With the launch of the new SCAN function in 2022, there is a much, much easier way to calculate running totals. Please see the SCAN function post. I’m leaving this here as a reference for the MMULT function.]

In this post we’ll look at how to calculate a running total, using a standard method and an array formula method. We’ll cover the topic of matrix multiplication (take a deep breath, it’s going to be ok!) using the MMULT formula, one of the more exotic, and challenging formulas in Google Sheets.

If you like video tutorials, here’s the one on MMULT:

This is a lesson from my latest, Google Sheets course on Advanced Formulas 30 Day Challenge (it’s free!).

Continue reading Running Total Array Formulas Using The MMULT Function