Word允许您计算表格中列的总和,就像在Excel等电子表格程序中一样。这篇文章将向您展示如何在Word 2003、2007(Word 2003)和 2010/2013/2016 中执行此操作。例如,我们将汇总一列十进制数字。
字 2007 至 2016
打开Word并将光标放在包含要求和的数字的列底部的空白单元格中。
表格工具(Table Tools)选项卡变为可用。单击布局(Layout)选项卡。
单击数据(Data)组中的公式(Formula)按钮。
正确的公式会自动插入到“公式”对话框的“公式(Formula)”(Formula)编辑框中。我 从数字格式(Number format)下拉列表中选择了0.00来格式化数字,就像列中其他数字的格式一样。(0.00)根据您的数据,您可以选择不同的数字格式。
单击“确定(OK)”接受设置。
公式字段被插入到单元格中,并自动计算和显示总数。如果您更改金额(Amount)列中的任何数字,请右键单击总计并从弹出菜单中选择更新字段以更新总计。(Update Field)您也可以在选择字段时按F9来更新它。
在Word(Word)中使用这样的公式时有一个很大的警告。数据都应该是连续的,这意味着数据中不应该有中断。例如,看看下面的数据。对于3 月份(March),第二列中没有数据。
因此,不是对从Jan到June的所有内容求和,而是对从(June)April到June的值求和。现在,如果我在单元格中输入 0 并更新该字段,那么它会给我正在寻找的正确答案。
显然,请记住这一点并检查您的结果以确保它们是正确的。这些类型的问题通常不会出现在Excel 中(Excel),因为您必须准确指定要在哪些单元格上执行计算,但在Word中,情况并非如此。
您可能还会注意到,在 Word 布局(Layout)选项卡或任何其他选项卡上看不到AutoSum按钮。(AutoSum)此功能在Word中可用,但不在任何功能区选项卡上。要访问它,您必须将其添加到快速访问(Quick Access)工具栏。为此,请单击Office按钮,然后单击Word 选项(Word Options)按钮。在较新版本的Word中,单击文件(File),然后单击选项(Options)。
从Word 选项(Word Options)对话框左侧的列表中选择自定义选项。(Customize)较新(Newer)版本的Word,您必须选择快速访问工具栏(Quick Access Toolbar)。
从从(Choose commands from)下拉列表中选择命令中选择不在功能区(Commands Not in the Ribbon)中的命令。
在下拉列表中选择命令(Choose commands from)下方的列表中向下滚动,直到找到Sum命令。选择它并单击添加(Add)按钮。这会将Sum命令添加到(Sum)Word 选项(Word Options)对话框右侧的快速访问工具栏(Quick Access Toolbar)上的命令列表中。
单击“ Word 选项(Word Options)”对话框上的“确定”将其关闭。(OK)Sum命令在快速访问工具栏(Quick Access Toolbar)上显示为一个按钮。当光标位于前面讨论过的表格的金额(Amount)列的最后一个单元格时,您可以单击求和按钮以合计列中的数字。(Sum)
不幸的是,您不能直接在Word中自定义功能区选项卡 。我们的帖子“自定义 MS Office 功能区”中讨论了有关自定义和使用功能区栏中的命令的更多提示。
词 2003
下面是一个示例表,我们将使用它来向您展示如何在(Below)Word 2003中对表格中的一列数字进行合计。要对Amount(Amount)列中的数字求和,请将光标放在该列的最后一个单元格中。
从表格(Table)菜单中选择公式。(Formula)
公式(Formula)对话框上的公式(Formula)编辑框会自动填充适当的公式。我们将按照金额(Amount)列中数字的格式设置总计的格式。从数字格式(Number format)下拉列表中选择0.00 。
单击“确定(OK)”接受您的设置。
总额输入到金额(Amount)列的最后一个单元格中。
就是这样!值得注意的是,如果您愿意,您可以在公式框中插入更复杂的公式,但Word并不支持Excel支持的所有公式,所以如果您尝试(Excel)Excel公式并得到一个,请不要感到惊讶错误。要查看您可以在Word中使用的所有公式的列表,请通过向下滚动到可用函数部分来查看 Microsoft 的此列表。(list from Microsoft)享受!
Sum a Table Column in Word
Word allows you to calculаte the sum of a column in a table, just like you would in a spreаdsheet program like Excel. This poѕt will show yoυ how to do this in Word 2003, 2007, and 2010/2013/2016. As an еxample, we wіll total a column of decimal nυmbers.
Word 2007 thru 2016
Open Word and put the cursor in the blank cell at the bottom of the column that has the numbers you want to sum.
The Table Tools tabs become available. Click the Layout tab.
Click the Formula button in the Data group.
The correct formula is automatically inserted into the Formula edit box on the Formula dialog box. I selected 0.00 from the Number format drop-down list to format the number the same way the other numbers in the column are formatted. Depending on your data, you can pick a different number format.
Click OK to accept the settings.
The formula field is inserted into the cell and the total is automatically calculated and displayed. If you change any of the numbers in the Amount column, right-click on the total and select Update Field from the popup menu to update the total. You can also press F9 while a field is selected to update it.
There is one big caveat when using formulas like this in Word. The data should all be contiguous, meaning there should be no breaks in the data. For example, take a look at the data below. For the month of March, there is no data in the second column.
So instead of summing everything from Jan to June, it’s only summing the values from April thru June. Now if I put a 0 in the cell and update the field, then it gives me the correct answer I was looking for.
Obviously, keep this in mind and check your the results to make sure they are correct. These types of problems don’t normally occur in Excel because you have to specify exactly which cells you want to perform the calculations on, but in Word, that’s not the case.
You may also notice that you don’t see an AutoSum button on the Word Layout tab or any of the other tabs. This feature is available in Word, but it is not on any of the ribbon tabs. To have access to it, you must add it to the Quick Access toolbar. To do this, click the Office button and click the Word Options button. In newer versions of Word, click on File and then Options.
Select the Customize option from the list on the left side of the Word Options dialog box. Newer versions of Word, you have to select Quick Access Toolbar.
Select Commands Not in the Ribbon from the Choose commands from drop-down list.
Scroll down in the list below the Choose commands from drop-down list until you find the Sum command. Select it and click the Add button. This adds the Sum command to the list of commands on the Quick Access Toolbar on the right side of the Word Options dialog box.
Click OK on the Word Options dialog box to close it. The Sum command displays as a button on the Quick Access Toolbar. You can click the Sum button when the cursor is in the last cell of the Amount column of the table discussed earlier to total the numbers in the column.
Unfortunately, you cannot customize the ribbon tabs in Word directly. More tips about customizing and using commands from the ribbon bar are discussed in our post, Customize the MS Office Ribbon.
Word 2003
Below is an example table we will use to show you how to total a column of numbers in a table in Word 2003. To sum the numbers in the Amount column, put the cursor in the last cell in that column.
Select Formula from the Table menu.
The Formula edit box on the Formula dialog box is automatically filled in with the appropriate formula. We will format the total the same way the numbers are formatted in the Amount column. Select 0.00 from the Number format drop-down list.
Click OK to accept your settings.
The total is entered into the last cell in the Amount column.
That’s about it! It’s worth noting that you can insert more complex formulas into the formula box if you like, but Word doesn’t support all of the formulas that are supported by Excel, so don’t be surprised if you try an Excel formula and you get an error. To see a list of all formulas you can use in Word, check out this list from Microsoft by scrolling down to the available functions section. Enjoy!