قالب وردپرس درنا توس
Home / Tips and Tricks / How do you sum rows and columns in Microsoft Word?

How do you sum rows and columns in Microsoft Word?

  Word Logo

If you need to sum values ​​in a Word spreadsheet, you can do so without breaking the calculator, or entering and then copying the data in Excel. Word can do simple calculations like summing, multiplying, and averaging.

Let's say you have a table that resembles the following. You sold the units and the unit costs, and you want to multiply them to get a total.

  Sales Table in Word

Begin by inserting the insertion point into the empty top cell in the Sum column.

Next, go to the new Layout tab, which appears at the right end of the Ribbon (there is a separate tab-only Layout tab), and click the Formula button.

 Click the Formula button on the Layout tab.

In this example, multiply the value in the Units column by the value in the Unit Cost column. To do this, type the following in the Formula field to multiply the values ​​in the two cells to the left of the current cell:


Select an option from the Number Format drop-down list, to specify the format for the result of the formula.

Click "OK" to apply the settings and paste the formula into the cell.

The result of the formula indicates in the cell.

 The grand total is now displayed in the cell.

Unfortunately, you can not use Word to select a set of cells at once and create a formula for all the cells in a cell step, so you need to perform these steps in each of the other cells in the "Total" column.

When finished, you have a fully formed table.

This technique works just as well for columns as it does for rows. For example, suppose we wanted to add all the values ​​in the Total column to get the total revenue.

Place your insertion point in an empty cell at the bottom of the "Total" column (add an extra row if you need to). Go to the "Layout" tab and click on the "Formula" button again.

This time we use the following formula:

  = SUM (ABOVE) 

The "ABOVE" parameter instructs Word to add all values ​​above the current cell.

Select a suitable number format and click "OK".

The sum of all values ​​in the Total column is displayed in the cell.

Note: When you add new rows or value columns to a table in Word, the formulas you use are not automatically updated. To update a formula, right-click the formula and choose Update Field from the pop-up menu.

When it comes to managing data in spreadsheets, Word is far from the power of Excel. For small tables like these, it's fine you do not expect the values ​​to change dramatically, and you do not have to display your data in different ways. If you need more features, it is much better if you insert a real Excel spreadsheet into your Word document.

Source link