but I want to format it to automatically calculate a column of dollars
You need to tell us please what you want the calculation to do so for example do you want to add amounts in columns 1 and 2 and put the result(s) in column 3?
This browser is no longer supported.
Upgrade to Microsoft Edge to take advantage of the latest features, security updates, and technical support.
How do I insert a table in a Word document - that can be used to total currency automatically?
I know how to insert the table, but I want to format it to automatically calculate a column of dollars
Locked Question. This question was migrated from the Microsoft Support Community. You can vote on whether it's helpful, but you can't add comments or replies or follow the question.
but I want to format it to automatically calculate a column of dollars
You need to tell us please what you want the calculation to do so for example do you want to add amounts in columns 1 and 2 and put the result(s) in column 3?
I want one column
Enter dollar amounts (+ and or - dollars)
| $10,000.00 | Amount |
| $500.00 | Plus |
| $100.00 | Plus |
| $4,000.00 | Minus |
| $6,600.00 | TOTAL |
In the table that contains the column of dollar amounts, create another row at the bottom of the table. In the cell of that row that's in the same column as the amounts, go to the Layout tab of the ribbon at the far right (NOT the Layout tab to the left of the References tab) and click the Formula button to open the Formula dialog.
The Formula box in the dialog should default to = SUM(ABOVE) but you can enter that if it defaults to something else. Normally the formula will format the result the same as the entries in the column, but you can pick the dollar format from the dropdown of the Number format box if need be. Click OK. The resulting sum will appear where the cursor was:
A few things to note about this:
Form more information about table formulas, see https://support.microsoft.com/en-us/office/use-a-formula-in-a-word-or-outlook-table-cbd0596e-ea8a-485e-a35d-b2cb2c4f3e27
I want one column
Enter dollar amounts (+ and or - dollars)
$10,000.00 Amount $500.00 Plus $100.00 Plus $4,000.00 Minus $6,600.00 TOTAL
I’ve just put up a file for you at:-
- which shows you one way in which it might be done.
Download the file and open it clicking:-
Enable Editing
- if necessary.
Go to page 4 of 4 where you can see the image below.
Does that give you what you want?
PS - you may find this helpful:-
Use a formula in a Word or Outlook table - Word for Microsoft 365