Follow the instructions for adding columns of numbers, but use the following formula, =PRODUCT(ABOVE).įormulas can get quite complex. You can also multiply columns of numbers in a Word table. Multiplying columns of numbers in a table Here is the link to Greg’s article with the macro code. Greg Maxey, Microsoft MVP, wrote a macro that reports the cell ranges. If you have split/merged cells, it can be difficult to figure out the correct cell references.
One thing to check is that there are actually the number of rows and columns you think there are. This will add all of the numbers in columns A, B, C, from cells 1-39. If you are trying to add all of the numbers in the entire table, you have to use a range, as follows:
To find the name of a table cell, manually count the columns (A, B, C…) and the rows (1, 2, 3…). When the Formula window opens, it’s time to get to work on your quick calculation. Move to the right side of the ribbon and click Formula in the Data section. Then, head to the Layout tab that appears. However, you may not realize that table cells in Word are named the same way. After you insert or draw your table in Microsoft Word and fill it with data, select the cell where you want to add the formula. In Excel, the cells have names such as D2 or H15. You can also enter zero in the empty cell. Add a Formula to a Table Cell in Word After you insert or draw your table in Microsoft Word and fill it with data, select the cell where you want to add the formula. If your table contains blank cells, you need to add the cell names to the formula to make it work. The sum formula works for adjacent cells. If the formula appears in the cell instead of the sum, press Alt + F9. You do not have to type the curly brackets Word 2007 places the formula inside curly brackets for you when it inserts the formula into the table cell. There must be an opening AND closing bracket. Under Formula, type this formula exactly: =SUM(ABOVE)Ĭaution: Make sure there are no spaces between characters, and that ABOVE is inside ().On the Table Tools Layout tab (this tab is only visible if your cursor is inside the table), click Formula.Ĭlick inside the table then click Formula on the Tables tab.Place the cursor in the cell where you want the sum displayed.Create a table with a column of numbers.To add a column of numbers in a table, follow these steps: Calculating a sum in a Microsoft Word table
#HOW TO ADD FORMULAS IN WORD HOW TO#
It must be entered using a dialog box.įor the benefit of readers who don’t know how to use basic math calculations in Microsoft Word tables, let’s start at the beginning of the process. (The closing parentheses was missing in Trish’s forumula.) However, you cannot type the formula directly into the cell. However, when I try to get a total in the cell under my column, all I get is “syntax error”.
0 kommentar(er)
