Word will then calculate the sum of all the cells above the cell where the formula is located provided they all contain numbers. Sum the values based on another column if ends with certain text. Then press Ctrl F9 to insert a field in the.
This is a grocery list with a range that contains specific repeated text.
In order to add the sum range based on a specific text criteria we need to. Then you have table appearance and Excel functionality both. SUMRIGHT The sum of the values of the cells to the right of the formula. Start by placing your insertion point into the blank top cell in the Total column.