With this formula Word will add up all the numbers that occur above the cell in which the formula is located. Take column D for the brand of cars as criteria and column E for the total quantity of cars sold. Click in a cell that should contain the sum of the rows.
In the Formula box check the text between the parentheses to make sure Word includes the cells you want to sum and click OK.
You can also use the SUMPRODUCT function to know the number of cells with text. Word contains a powerful to allow you to build Excel-like formulas in your Word documents. Range required argument This is the range of cells that we want to apply the criteria against. Click the target cell in your table open the Layout tab and click Formula in the Data section.