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

Amazing! Using Tabs In Word Like Firefox, Chrome, Internet Explore 10!

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

---

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:

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.

---

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.

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:

Impressi 9 Banner + Impressi 15 Banner + Impressi 30 Banner + Impressi 45 Banner + Impressi 60 Banner

Impressi 30 Banner