Once it hits an empty cell, Word stops calculating. Try retyping these numbers to see if that fixes the problem. In some cases, you may have typed a number which Word sees as text instead. text) in the column above and add up the rest of the cells.
Word will then calculate the sum of all the cells above the cell where the formula is located provided they all contain numbers.
This will insert the SUM formula into the cell. Once you've chosen a format, you can click OK. For example, the following format is not listed but will work to format the number with a $ sign, thousand separators and two decimal places: The list of available number format is somewhat limited, but you can manually enter any format that is supported by Excel. You can now choose a format for the number. Note - if you get an error rather than one of these formula, it most likely means that Word couldn't find any numbers in the cells above or to the left of the current cell. Then, in the last row in the table, click in the cell in the number column and choose Insert > Quick Parts > Field, then click FormulaĪ new dialog box should appear containing a Formula field with one of the following formulas: Enter the numbers, making sure that there is a number in each cell in the column. Note that you can't just add up numbers on different lines - you can only add up numbers that are presented in either a column or a row inside a table.įirst, create your table and decide which column or row will hold the numbers you wish to add up. This can also eliminate the possibility of error - particularly important if you're producing a sales proposal or an important report. If you're using Word to present a table of data that includes numbers, you can use Word's built in formulas to add up those numbers rather than manually calculate them each time they change.
0 kommentar(er)
