Skip to main content

Kutools for Office — One Suite. Five Tools. Get More Done.

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

Author Sun Last modified

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

Sum a column of a table in Word

Office Tab: Brings tabbed interfaces to Word, Excel, PowerPoint...
Navigate through documents using Office Tab
Enhance your workflow now.      Learn More about Office Tab       Free Download

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

A table with numbers

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

Formula button on the Layout tab of the ribbon

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

Formula dialog box

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

Numbers in the first column of the table are totaled

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

Sum 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:

Formula button on the Layout tab of the ribbon

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

Formula dialog box

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

Numbers in the first row of the table are totaled

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

Do 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.

Formula button on the Layout tab of the ribbon

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:

Formula dialog box with '=' in the formula text box
Arrow
Formula dialog box with the MAX function in the formula text box

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 type LEFT, see screenshot:

Formula dialog box with 'MAX(LEFT)' in the formula text box

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

Numbers in the first row of the table are totaled

Relative articles:

Best Office Productivity Tools

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

🤖 Kutools AI Features: AI Assistant / Real-Time Assistant / Super Polish (Preserve Format) / Super Translate (Preserve Format) / AI Redaction / AI Proofread...

📘 Document Mastery: Split Pages / Merge Documents / Export Selection in Various Formats (PDF/TXT/DOC/HTML...) / Batch Convert to PDF...

✏ 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 / Text Boxes / Hyperlinks / For more removing tools, head to the Remove group...

➕ Creative Inserts: Insert Thousand Separators / Check Boxes / Radio Buttons / QR Code / Barcode / 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...

🌍 Supports 40+ Languages: Use Kutools in your preferred language – supports English, Spanish, German, French, Chinese, and 40+ others!

Kutools and Kutools Plus tabs on the Word Ribbon
👉 Want to try these features? Download Kutools for Word now! 🚀
 

✨ Kutools for Office – One Installation, Five Powerful Tools!

Includes Office Tab Pro · Kutools for Excel · Kutools for Outlook · Kutools for Word · Kutools for PowerPoint

📦 Get all 5 tools in one suite | 🔗 Seamless integration with Microsoft Office | ⚡ Save time and boost productivity instantly

Best Office Productivity Tools

Kutools for Word - 100+ Tools for Word

Free Download Buy Now Learn More about Kutools