How to find the sum of all the values in a column? You might not even say wait, before you tell me how you can do it. But wait, did I tell you that it’s not Excel, but Word? In Excel, everyone knows how to apply a formula function and find the sum of all the values in a column. But when it comes to Microsoft Word, people often depend on a calculator to find the sum of values or take the data from Word to Excel, do the calculations, and then it put it back on Word. Well, both the solutions are not ideal, for obvious reasons. Wondering what else can be done? Would you believe it if I tell you that it is easier to find the sum of values in Word than it is in Excel? You have to, because that’s the reality!
In this article, we tell you how you can quickly find the sum of all the values in a column in Microsoft Word, with the help of some inbuilt functionalities, through 2 different solutions. Hope you enjoy!
Solution 1: Through Layout Tab Data Formula
Step 1: Let’s say you have the following table. We need to find the sum of the values in the second column.
For that, click on the cell where you want the sum value to be calculated.
Now, you will be able to see 2 contextual tabs namely Design and Layout. Click on the LAYOUT tab. As next, under the Data section of the LAYOUT tab, click on the button named Formula.
Step 2: On the Formula window, under the field Formula, the =SUM(ABOVE) function will be already populated. If not, simply copy and paste it.
Once done, hit the OK button.
Step 3: That’s it. If you now look at your Excel sheet, you can see that the sum of the values is calculated and dispalyed on the cell you selected.
Extra Cookie Section
By default, the sum function would be auto-populated as =SUM(ABOVE). It means, to sum all the values above the selected cell. You can customize it and make it =SUM(BELOW), which will sum all the values under the selected cell. Likewise, if you use the function =SUM(LEFT), it will sum all the values to the left of the selected cell, just like how =SUM(RIGHT) will sum all the values to the right of the selected cell.
Solution 2: By Customizing Quick Access Toolbar
If you are someone who needs to find the sum of values frequently in Microsoft Word, then you can add the Sum functionality to your Quick Access Toolbar. In that case, every time you need to find a sum, you just need to click on this button on the Quick Access Toolbar. Let’s see how this can be done.
Step 1: Right click anywhere on the Quick Access Toolbar. From the right click context menu options, click on the one that says Customize Quick Access Toolbar.
Step 2: On the Word Options window, Quick Access Toolbar will be automatically selected in the left window pane.
In the center pane of the window, click on the dropdown arrow icon associated with the option Choose commands from.
From the list of options available in the dropdown, click on the one that says All Commands.
Step 3: Now, scroll through the list of options available and click on the one that says Sum. Click on the Add >> button next.
Step 4: Now, the Sum functionality will be added to the right pane of the window. Hit the OK button to proceed.
Step 5: The Sum function is now successfully added to the Quick Access Toolbar.
You can now simply click on the cell where you want the Sum value to be displayed and then click on the Sum button on the Quick Access Toolbar to calculate the sum.
Step 6: Viola! The sum is now generated, with just a single click.
Please tell us in the comments section whether you found the article helpful or not. If you found it helpful, do share it with your friends and colleagues.
Stay tuned, we have many more new technical articles coming, all on your favorite topics.
Here to enlighten, and to be enlightened, with the amazing world of tricks, tips, how-tos, and hacks.