From the course: Excel: Financial Functions in Depth

Unlock this course with a free trial

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

Introduction to LAMBDA functions with BYCOL and BYROW

Introduction to LAMBDA functions with BYCOL and BYROW - Microsoft Excel Tutorial

From the course: Excel: Financial Functions in Depth

Start my 1-month free trial Buy for my team

Introduction to LAMBDA functions with BYCOL and BYROW

“

- [Instructor] We've talked a bit in previous chapters about dynamic array ranges. And here's an example of a beautiful dynamic formula that is going to automatically expand and contract as we change the number of years in the schedule. What you might've noticed though, is that as we change it, this SUM formula down below doesn't automatically expand and contract because it's not dynamic. So, what we can do, now that we know how to use the hash, is that we could replace that with a hash and we can use a SUM there, but that is not giving us the correct result because it is summing absolutely everything in the range. All we want to do here is to sum up the column only. So, this is where we are going to use the BYCOL function. And this is a new type of Lambda function that they have introduced specifically for this type of calculation. Now, if you are using an older version, you may need to write out the Lambda. So, let's have a look at how to do that. If we were to use the BYCOL, it's…

Contents