For example if you insert table formulas in Word in a cell at the end of a column of continuous numbers Word assumes you want to add the cell values in the column above the cell. For instance here we put it in. To use the SUMPRODUCT function select a cell and type in the following formula.
To reference the contents of a table cell type the cell references in the formula.
SUMIF rangecriteriasum_range In this example we need to use SUMIF function for a partial text in the range as we want to know the total number of cars sold in various countries. Sum an Entire Direction. SUMIFA2A6KTEB2B6 A2A6 is the data range which you add the values based on KTE stands for the criterion you need and B2B6 is the range you want to sumsee screenshots. Unfortunately this formula would simply add all the numbers to the left of the cell ie.