00:00After calculating the running total with a quick analysis tool, inserting a brand new line creates
00:04a blank row like this. Here's the correct method of calculating running total where the blank lines
00:10are automatically filled as we add more lines to our data set. Traditionally, if you want to
00:16calculate running total, what you do is you go ahead and select all your sales value or whatever
00:20the values that you want to have a running total against. Then there's an icon here at the bottom
00:24right hand corner. Click on it. That's the quick analysis icon. After that, you're going to click
00:28on this total tab here and then you're going to navigate all the way to the far right hand side
00:34and click on running total here. If you click on it, you'll do a quick analysis running total for you.
00:40But if you want a proper solution, you have to use a scan function. Let me explain. You're going to
00:46say
00:46equal scan open parenthesis. Since this is going to be a running total, so the first value or the
00:53initial value, we're going to start with zero and comma. The second argument is your array or the
01:00range of value you're going to apply the running total against. You're going to select your sales.
01:04And then the third argument is essentially your function, right? I've seen in YouTube where people
01:09just say sum. This doesn't really work. It'll give you this error. The best way to do is to write
01:14a
01:14lambda formula. The first argument in lambda will be a comma b. So basically you're taking the first
01:20cell value and there's b is your second cell value. And the third argument is where you do a
01:24summation. We're going to say a plus b. Close parenthesis and hit enter. No doubt the running
01:30total matches for both methods. The quick analysis method creates an empty cell when you add a new
01:36row to your data set. But the scan function, well, is superior as it fills the blank cells up for
01:42you
01:42automatically.
Comments