How To Add Formula To A Table In Word 

In this chapter, we will discuss how to add formula to a table in Word. Microsoft Word allows you to use mathematical formula in table cells which can be used to add numbers, to find the average of numbers, or find the largest or the smallest number in table cells you specify.

There is a list of formulae that you can choose from based on the requirements. This chapter will teach you how to use formulas in word tables.

Formula

Start your formula with an equal sign, and then type your function, such as AVERAGE, COUNT, or PRODUCT. In the parentheses, add the position of the cells you want to use for the formula. Use the positions ABOVE, BELOW, LEFT, and RIGHT.

Depending on where the cells are in relation to the formula, you can also combine positions. For example, you can use LEFT, RIGHT for cells to the left and right, or LEFT, ABOVE for cells to the left and above the cell.

How To Add Formula To A Table In Word 

Here are some easy steps for adding a formula to a table cell in a Word document.

  • Step 1: First, click the tab that says Layout. Click “Formula” in the Data section on the right side of the ribbon.

    LAYOUT TAB AND FORMULABUTOON

  • Step 2: This will bring up a Formula Dialog Box with a default formula, which in our case is =SUM(LEFT).

    Using the Number Format List Box, you can choose how to show the result. Using the Formula List Box, you can change the formula.FORMULA DIALOG BOX

  • Step 3: Click OK to use the formula.

    CLICK OK TO GET THE SUM

  • You’ll see that the above cells have been added together and the total has been put in the total cell, where we wanted it.

    You can do the same thing again to get the sum of the other two rows.RESULT OF FORMULA

List of Cell Formulae You can Use

The table shows the Formula dialog box that provides the following important functions to be used as formulas in a cell.

Formula& Description
AVERAGE( )The average of a list of cells
COUNT( )The number of items in a list of cells
MAX( )The largest value in a list of cells
MIN( )The smallest value in a list of cells
PRODUCT( )The multiplication of a list of cells
SUM( )The sum of a list of cells

Word Table Formula Cell Reference

The following are useful points to help you in constructing a word cell formula.

Cell ReferencesDescription
A single cell reference,B3 or F7
A range of cells,A4:A9 or C5:C13
A series of individual cells,A3, B4, C5
ABOVErefers to all cells in the column above the current cell.
BELOWrefers to all cells in the column below the current cell.
LEFTrefers to all cells in the row to the left of the current cell
RIGHTrefers to all cells in the row to the right of the current cell
Word Table Formula Cell Reference

Summary

In the end, we’ve learned how to add a formula to a table in Word and what those terms mean. We also know that different formulas can be used, which we can use in our document to make it look more professional and presentable.

Meanwhile, if you want to learn more about working on tables, see the previous tutorial on how to resize tables and how to merge and split tables in Microsoft Word. You can browse those guides if you are having a hard time working with your tables in a document.

Insert Caption to Tables, Figures,...
Insert Caption to Tables, Figures, and Equations in Microsoft Word

We hope this tutorial helps you as you format your documents in MS Word.


Leave a Comment