跳到主要内容

如何插入公式以求和Word中表格的一列或一行?

您可能知道如何在Excel中求和或计算数据,但是您知道如何对Word文档中的表的列或行中的数据求和吗? 让我们谈谈在Word中计算表中数据的方法。

在Word中对表的列求和

在Word中求和表的一行

在Word中的表中进行其他计算


箭头蓝色右气泡在Word中对表的列求和

Office 选项卡:为 Word、Excel、PowerPoint 带来选项卡式界面...
ot字中间广告100
立即增强您的工作流程。      了解更多       免费下载

如果要汇总如下所示表格的列数据,可以执行以下步骤:

步骤1.将光标放在第一列的空白单元格上,然后单击 布局 > 公式,请参见屏幕截图:

步骤2.将显示一个名为Formula的对话框,键入 = SUM(以上) ,在 公式 文本框。 看截图:

步骤3。 点击 OK。 然后将以上数据加在一起,结果显示在空白单元格中。 看截图:

提示: 要汇总空白单元格下方的相同列数据,请输入 = SUM(以下) ,在 公式 文本框。


箭头蓝色右气泡在Word中求和表的一行

如果要对Word文档中的表的行求和,请执行以下操作:

步骤1.将光标放在第一行的空白单元格上,然后单击 布局 > 公式,请参见屏幕截图:

步骤2.名为的对话框 公式 显示,键入 = SUM(左) 在公式文本框中。 看截图:

步骤3。 点击 OK。 然后将第一行的所有剩余数据相加,结果显示在空白单元格中。 看截图:

提示:要对空白单元格右侧的相同行数据求和,请输入 = SUM(右) 在“公式”文本框中。


箭头蓝色右气泡在Word中的表中进行其他计算

在Word中,您可以在表中进行其他计算,例如平均值,产量等。

步骤1.单击要显示计算结果的空白单元格,然后单击 布局 > 公式.

步骤2.名为的对话框 公式 显示,键入 “ =” 在公式文本框中,然后从粘贴功能列表中选择要应用的功能。 在这种情况下,我选择 max.。 查看屏幕截图:

第3步。 公式 文本框,请执行以下操作:

  • 键入上方以计算空白单元格上方的所有数据。
  • 键入下面以计算空白单元格下面的所有数据。
  • 键入LEFT以计算空白单元格左侧的所有数据。
  • 键入RIGHT以计算空白单元格右侧的所有数据。

在这种情况下,我打字 ,请参见屏幕截图:

步骤4。 点击 OK,您可以看到如下所示的结果:


相关文章:

最佳办公生产力工具

Kutools for Word - 通过 Over 提升您的文字体验 100 显着特点!

深入了解下面突出显示的功能或 单击此处探索 Kutools for Word 的全部功能.

📘 文档掌握: 分页  /  合并文件  /  以各种格式导出选择(PDF/TXT/DOC/XLSX)  /  批量转换为PDF  /  将页面导出为图像  /  一次打印多个文件 ...

内容编辑: 批量查找和替换 跨多个文件   /  调整所有图片的大小   /  转置表行和列  /  将表格转换为文字 ...

🧹 轻松清洁扫开 多余的空间  /  分节符  /   所有标题  /  文本框  /  超链接  /  如需更多删除工具,请前往我们的删除组

创意插入: 插页 千位分隔符  /  复选框  /  单选按钮  /  二维码  /  条码  /  对角线表  /  公式标题  /  图片说明  /  表标题  /  多张图片  /  在我们的插入组中发现更多信息

🔍 精准选择: 精确定位特定页面  /    /  形状  /  标题段落  /  使用我们的选择组轻松导航

星级增强: 快速导航至任何位置  /  自动插入重复文本  /  在文档窗口之间无缝切换  /  11 转换工具 ...

使用 Kutools 转换您的 Word 任务。 👉 立即下载并试用 30 天 🚀。

了解更多       免费下载      购买
 
Comments (20)
No ratings yet. Be the first to rate!
This comment was minimized by the moderator on the site
I am trying to add together the C3 through S3. It says Syntax Error. So....?
This comment was minimized by the moderator on the site
What if I want to, say multiply the number in column 3 by the number in column 4 on the row?
This comment was minimized by the moderator on the site
There are 5 cells going across "Total" and the number, a second "Total" and the number and "Total" where the sum of both should be. Sum left is only pulling the number to the left and not adding the other numbers in the row. I used the formula =SUM(LEFT). Does it not work when there is text? How can I make this work?
This comment was minimized by the moderator on the site
I was looking for a similar solution and didn't find one. However, I found a work around. At the end of the text string, I included a zero and change the color the font to white. This allowed my formula to calculate across rows that had text in them. This is a fix for a very basic table. Hope this helps.
This comment was minimized by the moderator on the site
I need the answer to this one too...did you find it? There are blank cells between the amounts you want to sum. I think you can just put a zero as a placeholder in the blank cells
This comment was minimized by the moderator on the site
how to get 5 X 10 = 50 this but both a in same raw but different column between them have UNIT column so how to solve this issue?
This comment was minimized by the moderator on the site
Hello Ahmad,

You can achieve this with:
PRODUCT(LEFT)
Then it will multiply every column on the left side of the calculation field column.
This comment was minimized by the moderator on the site
how to sum table in Word
This comment was minimized by the moderator on the site
To sum the columns above you need to make sure that no row is empty and use:
SUM(ABOVE)
This comment was minimized by the moderator on the site
could you explain me how can i prepare MIS in Ms Word file can u send the sample file in my email id
This comment was minimized by the moderator on the site
Does it recalculate when the numbers change?
This comment was minimized by the moderator on the site
Click F9 key to recalculate the cell
This comment was minimized by the moderator on the site
HI, When I use the above formula the formula is displayed in the cell but the it is not calculating, please let me know if we need to to any setup changes
This comment was minimized by the moderator on the site
could you explain me how can i prepare MIS in Ms Word file can u send the sample file in my email id
This comment was minimized by the moderator on the site
how to sum table in Word
There are no comments posted here yet
Load More
Please leave your comments in English
Posting as Guest
×
Rate this post:
0   Characters
Suggested Locations