From the course: Excel: Financial Functions in Depth

Unlock this course with a free trial

Join today to access over 24,600 courses taught by industry experts.

Building a cumulative sum with SCAN

Building a cumulative sum with SCAN - Microsoft Excel Tutorial

From the course: Excel: Financial Functions in Depth

Start my 1-month free trial Buy for my team

Building a cumulative sum with SCAN

“

- [Instructor] If you had a list of sales like this and wanted to work out how much we've sold cumulatively each month, there are a couple of different ways of doing this, and some are better than others. Firstly, you could just look at the first month, and then you could look at the previous one plus the current month and copy that down. Now that would work, but you have inconsistent formulas, which is generally not best practice, but hey, that will work. The other way of doing it would be to do a sum formula, put in a colon, and then just go back into the formula, and use your F4 shortcut or just type in the dollar signs. If I drag that down, you can see that it's going to sum it cumulatively as the months go on. Now there is a new type of function. It's again, a Lambda function, which you can use together with dynamic formulas. So to do this, it's called a scan, and you need to put in your initial value, which in this case is zero, and the array is going to be the sales, and then…

Contents