You don’t have to use the SUM function if you want to sum numbers. But when you use more complicated calculations you may find it very useful.
Summing numbers entered from the keyboard
You can use the SUM function when you enter numbers from the keyboard. All numbers that are separated by a comma will be summed.
will return 5.35.
In the following example, there are numbers that need to be summed up in columns. I will show you a few different ways how you can do this.
Summing ranges entered from the keyboard
Click cell B6, then enter the formula and press Enter. Excel will sum up numbers from cell B2 to cell B4.
Summing individual cells by clicking
In this method, click cell C6 and type =SUM(. Now, hold down the Ctrl key, click cell C2, then C3 and C4.
Summing cells using the mouse
Click cell D6, then type =SUM(. Drag your mouse from cell D2 to D4 and press Enter.
Summing cells using the keyboard
Select cell E6, then just as before, type =SUM( . Press the up arrow key twice to move it to cell E4. Then, while holding down the Shift key, press the up arrow twice again.
Press Enter to confirm.
Skillshare’s usually $10 a month, but because you’re an OfficeTuts reader you can get your first month free by clicking here. That’s unlimited access to over 18,000 classes on Excel, VBA, and much more.