Log in  \/ 
x
or
x
x
Register  \/ 
x

or

Kutools for Excel 22.00 HOT

300+ Powerful Features You Must Have in Excel

Kutools-for-Excel

Kutools for Excel is a powerful add-in that frees you from performing time-consuming operations in Excel, such as combine sheets quickly, merge cells without losing data, paste to only visible cells, count cells by color and so on. 300+ powerful features / functions for Excel 2019, 2016, 2013, 2010, 2007 or Office 365!

Read More Download Buy now

Office Tab 14.00HOT

Adding Tabbed Interface for Office

Office Tab

It enables tabbed browsing, editing, and managing of Microsoft Office applications. You can open multiple documents / files in a single tabbed window, such as using the browser IE 8/9/10, Firefox, and Google Chrome. It's compatible with Office 2019, 2016, 2013, 2010, 2007, 2003 or Office 365. Demo

Read More Download Buy now

Kutools for Outlook 13.00NEW

100+ Powerful Features for Outlook

Kutools-for-Outlook

Kutools for Outlook is a powerful add-in that frees you from time-consuming operations which majority of Outlook users has to perform daily! It can save your time from using Microsoft Outlook 2019, 2016, 2013, 2010 or Office 365!

Read More Download Buy now

Kutools for Word  9.00NEW

100+ Powerful Features for Word

Kutools-for-Word

Kutools for Word is a powerful add-in that frees you from time-consuming operations which majority of Word users have to perform daily! It can save your time from using Microsoft Word / Office 2019, 2016, 2013, 2010, 2007, 2003 or Office 365!

Read More Download Buy now

Classic Menu for Office

Bringing Back Your Familiar Menus

Restores the old look and menus of Office 2003 to Microsoft Office 2019, 2016, 2013, 2010, 2007 or Office 365. Don’t lose time in finding commands on the new Ribbon. Easy to deploy to all computers in enterprises and organizations.

Read More Download Buy now

How to insert formula to sum a column or row of table in Word?

You may know how to sum or calculate data in Excel, but do you know how to sum the data in a column or row of a table in Word document? Let’s talk about the methods of calculate the data in a table in Word.

Sum a column of a table in Word

Sum a row of a table in Word

Do other calculation in a table in Word


arrow blue right bubbleSum a column of a table in Word

Hot
Amazing! Use Efficient Tabs in Word (Office) like Chrome, Firefox and New Internet Explorer!

Read more Free download

If you want to sum a column data of the table shown as below, you can do as follow steps:

Step 1. Place the cursor at the blank cell of the first column, then click layout > Formula, see screenshot:

Step 2. A dialog named Formula is displayed, typing =SUM(ABOVE) in the Formula text box. See screenshot:

Step 3. Click OK. Then the above data are added together and the result is shown in the blank cell. See screenshot:

Tip: To sum the same column data below the blank cell, please type =SUM(BELOW) in the Formula text box.


arrow blue right bubbleSum a row of a table in Word

If you want to sum a row of a table in a Word document, do as follow:

Step 1. Place the cursor at the blank cell of the first row, then click layout > Formula, see screenshot:

Step 2. A dialog named Formula is displayed, typing =SUM(LEFT) in the formula text box. See screenshot:

Step 3. Click OK. Then all the left data of the first row are added together and the result is shown in the blank cell. See screenshot:

Tip: To sum the same row data on the right of the blank cell, please type =SUM(RIGHT) in the Formula text box.


arrow blue right bubbleDo other calculation in a table in Word

In Word, you can do other calculations in table such as average, production and so on.

Step 1. Click the blank cell you want to show the calculated result, then click layout > Formula.

Step 2. A dialog named Formula is displayed, typing "=" in the formula text box and select the function you want to apply from the Paste function list. In this case, I select Max. See screenshots:

Step 3. Between the parenthesis in the Formula text box, please do as follows:

  • Typing ABOVE to calculate all the data above the blank cell.
  • Typing BELOW to calculate all the data below the blank cell.
  • Typing LEFT to calculate all the data on the left of the blank cell.
  • Typing RIGHT to calculate all the data on the right of the blank cell.

In this case, I Typing LEFT, see screenshot:

Step 4. Click OK, you can see the result shown as below:


Relative articles:



Recommended Word Productivity Tools

 

Kutools For Word - More Than 100 Advanced Features For Word, Save Your 50% Time

  • Complicated and repeated operations can be done one-time processing in seconds.
  • Insert multiple images across folders into Word document at once.
  • Merge and combine multiple Word files across folders into one with your desired order.
  • Split the current document into separate documents according to heading, section break or other criteria.
  • Convert files between Doc and Docx, Docx and PDF, collection of tools for common conversions and selection, and so on...
Say something here...
symbols left.
You are guest
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 · 2 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.
      webjoko · 3 months ago
      You can achieve this with:
      PRODUCT(LEFT)
      Then it will multiply every column on the left side of the calculation field column.
  • To post as a guest, your comment is unpublished.
    jakammler@aol.com · 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 · 2 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 · 2 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.
      webjoko · 3 months ago
      Hello Ahmad,

      You can achieve this with:
      PRODUCT(LEFT)
      Then it will multiply every column on the left side of the calculation field column.
  • To post as a guest, your comment is unpublished.
    Ranjana · 3 years ago
    how to sum table in Word
    • To post as a guest, your comment is unpublished.
      webjoko · 3 months ago
      To sum the columns above you need to make sure that no row is empty and use:
      SUM(ABOVE)
  • To post as a guest, your comment is unpublished.
    Ranjana · 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.
    Chris · 3 years ago
    Does it recalculate when the numbers change?
    • To post as a guest, your comment is unpublished.
      Heather · 2 years ago
      Click F9 key to recalculate the cell
  • 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 · 3 years ago
      Really Really appreciate your ways of explanations.
      Anyways thanks a lot!!

Feature Tutorials