Skip to main content

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

Author: Sun Last Modified: 2017-03-07

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

Recommended Productivity Tools for Word

Kutools for Word: Integrating AI 🤖, over 100 advanced features save 50% of your document handling time.Free Download

Office Tab: Introduces the browser-like tabs to Word (and other Office tools), simplifying multi-document navigation.Free Download


arrow blue right bubbleSum a column of a table in Word

Office Tab: Brings tabbed interfaces to Word, Excel, PowerPoint...
ot word middle ad 100
Enhance your workflow now.      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:

Best Office Productivity Tools

Kutools for Word - Elevate Your Word Experience with Over 100 Remarkable Features!

🤖 Kutools AI Assistant: Transform your writing with AI - Generate Content  /  Rewrite Text  /  Summarize Documents  /  Get Quick Answers, all within Word

📘 Document Mastery: Split Pages  /  Merge Documents  /  Export Selection in Various Formats (PDF/TXT/DOC/HTML...)  /  Batch Convert to PDF  /  Export Pages as Images  /  Print Multiple Files at once...

Contents Editing: Batch Find and Replace across Multiple Files  /  Resize All Pictures  /  Transpose Table Rows and Columns  /  Convert Table to Text...

🧹 Effortless Clean: Sweap away Extra Spaces  /  Section Breaks  /  All Headers  /  Text Boxes  /  Hyperlinks  /  For more removing tools, head to the Remove group...

Creative Inserts: Insert Thousand Separators  /  Check Boxes  /  Radio Buttons  /  QR Code  /  Barcode  /  Diagonal Line Table  /  Equation Caption  /  Image Caption  /  Table Caption  /  Multiple Pictures  /  Discover more in the Insert group...

🔍 Precision Selections: Pinpoint Specific Pages  /  Tables  /  Shapes  /  Heading Paragraphs  /  Enhance navigation with more Select features...

Star Enhancements: Navigate to Any Location  /  Auto-Insert Repetitive Text  /  Toggle Between Document Windows  /  11 Conversion Tools...

👉 Want to try these features? Download Kutools for Word today and experience the difference! 🚀
Free Download     Read More     Buy Now
 
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
Leave your comments
Posting as Guest
×
Rate this post:
0   Characters
Suggested Locations