提示:其它语言是由 Google 机器翻译的。 你可以访问 English 版本。
登录
x
or
x
x
马上登记
x

or

如何插入公式在Word中的列或行的表中?

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

在Word中总结一个表格的列

在Word中总结一行表格

在Word中执行其他计算


箭头蓝色右泡在Word中总结一个表格的列

热卖
惊人! 使用Word(Office)中的高效选项卡,如Chrome,Firefox和新Internet Explorer!

了解更多 免费下载

如果您想对以下所示表格的列数据求和,您可以按照以下步骤进行操作:

步骤1。 将光标置于第一列的空白单元格处,然后单击 布局 > 公式,看截图:

步骤2。 显示一个名为Formula的对话框,输入 = SUM(ABOVE)公式 文本框。 看截图:

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

提示: 要将空白单元格下面的相同列数据相加,请键入 = SUM(下) 公式 文本框。


箭头蓝色右泡在Word中总结一行表格

如果您想在Word文档中总结一行表格,请执行以下操作:

步骤1。 将光标置于第一行的空白单元格处,然后单击 布局 > 公式,看截图:

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

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

提示:要汇总空白单元格右侧的相同行数据,请键入 = SUM(RIGHT) 在公式文本框中。


箭头蓝色右泡在Word中执行其他计算

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

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

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

步骤3。 在括号之间 公式 文本框中,请按照以下步骤操作:

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

在这种情况下,我打字 ,看截图:

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


相关文章:



推荐的Word生产力工具

Kutools For Word - 超过100 Word的高级功能,节省您的50%时间

  • 复杂和重复的操作可以在几秒钟内完成一次性处理。
  • 一次将多个图像跨文件夹插入Word文档。
  • 将多个文件夹合并并组合成一个具有所需订单的文件。
  • 根据标题,分节符或其他标准将当前文档拆分为单独的文档。
  • 在Doc和Docx,Docx和PDF之间转换文件,用于常见转换和选择的工具集合等等......
Say something here...
symbols left.
You are guest ( Sign Up? )
or post as a guest, but your post won't be published automatically.
Loading comment... The comment will be refreshed after 00:00.
  • To post as a guest, your comment is unpublished.
    Jae-Lex · 1 years ago
    What if I want to, say multiply the number in column 3 by the number in column 4 on the row?
  • To post as a guest, your comment is unpublished.
    Jean Kammler · 2 years ago
    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?
    • To post as a guest, your comment is unpublished.
      Mechael · 1 years ago
      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.
    • To post as a guest, your comment is unpublished.
      Heather · 1 years ago
      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
  • To post as a guest, your comment is unpublished.
    ahmad · 2 years ago
    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?
  • To post as a guest, your comment is unpublished.
    Ranjana · 2 years ago
    how to sum table in Word
  • To post as a guest, your comment is unpublished.
    Ranjana · 2 years ago
    could you explain me how can i prepare MIS in Ms Word file
    can u send the sample file in my email id
  • To post as a guest, your comment is unpublished.
    Chris · 2 years ago
    Does it recalculate when the numbers change?
  • To post as a guest, your comment is unpublished.
    Srivani · 3 years ago
    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
  • To post as a guest, your comment is unpublished.
    deepa · 3 years ago
    could you explain me how can i prepare MIS in Ms Word file
    can u send the sample file in my email id
  • To post as a guest, your comment is unpublished.
    Courtney · 4 years ago
    how to sum table in Word
  • To post as a guest, your comment is unpublished.
    Tito Tadios · 4 years ago
    HI am creating a document in a word format, but I need to put some figures and add them, are there simple way to create an addition formula in it? thanks for the help
  • To post as a guest, your comment is unpublished.
    # alex · 4 years ago
    I Have a row of numbers.. i want to plus 40% on all of them to save going through and manually doing it myself. any thought??
  • To post as a guest, your comment is unpublished.
    sandeep · 4 years ago
    hello

    could you explain me how shoul i sum many numbers in a table in which i got"-" dashes instead of "0"?

    i would really apprciate.
    best regards.
  • To post as a guest, your comment is unpublished.
    riccardo nicolai · 4 years ago
    Hi,

    could you explain me how shoul I sum many numbers in a table in which I got "-" dashes instead of "0"?

    I would really appreciate.

    Best regards,
    Riccardo Nicolai
    • To post as a guest, your comment is unpublished.
      YORDANOS · 2 years ago
      Really Really appreciate your ways of explanations.
      Anyways thanks a lot!!