00:00This excel tip is going to absolutely blow your mind. Say whenever you have to enter a sum function
00:05to add a series of number, you basically say sum like this and you select a series of numbers,
00:11comma, and then select a single cell, comma, let's say you want to add this, comma, and you want to
00:16add a series of range of cells, comma, and maybe a single cell, comma, and a single cell, and close
00:22parentheses and hit enter. That's how you get your sum function. You can see it tends to get a bit
00:27tedious if there's far too many arguments on your sum function. Let me show you a quick way to get
00:33around this comma bonanza. Say if you need to add a sum function, currently this guy, basically start
00:39off with sum function like this, and then select the range. And now if you need to add more cells
00:44into your argument, just hold down the control on your keyboard and select the single cell that you
00:50want to add to your sum function. As you can see, a comma gets automatically added to your sum function.
00:57If you want a range, keep holding your control key on the keyboard and select the range. And as you
01:01can
01:02see, a comma gets automatically entered. Close parentheses and hit enter. This technique also works
01:08for other functions like count. Let me show you what I mean by that. Say count, hold down your control
01:13key, or you can, the first one, you don't even have to hold down the control key, just select the
01:16range.
01:17And now for the second one, you can hold your control key on your keyboard and select however many
01:22cells you want. And if you're in range, well, keep holding out your control key and then drag and drag.
01:28Another function that can also work is average as well. Hold down your control key. I don't have
01:33to hold down the control key and select as many cells as you want. And there you go.
01:37So, let's go.
01:38So, let's go.
