Autosum in Word 2010 without data?

Question

Is there anyway I can autosum table columns in Word 2010 when the columns have no data in them, only to have it sum as I type numbers in?

Essentially what I want to make it so that when someone fills out the table column with numbers, the bottom cell of the column automatically sums it, just like the way Excel auto sums columns as you fill them out. I tried inserting an Excel spreadsheet in, but it messes up the formatting of the form I created

Answer 1

Unlike Excel, you can not have blank cells in a range to be totaled in Word. You can put 0 in a blank cell and it will total.



Autosum? I do not think this is possible in Word but you can insert an Excel spreadsheet in a Word doc. This is called OLE_ object linking and embedding.

http://www.dummies.com/how-to/content/how-to-embed-and-link-data-from-excel-2013-into-wo.html

Answer 2

You can do sums in a table, but they don't seem to automatically update if you change the contents in one of the cells.



To do a sum in the table, insert your table, remembering to put in an extra row (or column) for your sums. In the cell where you want to do the sum, click on the Table Tools > Layout menu and select Formula (fx) at the end of the ribbon). In the popup, enter =sum(above) or =sum(left) to sum up the numbers in the cells above (column sums) or to the left (row sums) of that cell. You can do some other formatting if you need, but you can just hit OK and it will calculate your sum.



I couldn't make it auto update, but if you make changes, click on the formula box again and just hit OK to recalculate.



If you need more help with this, go to Word Help and do a search for formula in a Word table. There are more formulas you can use in a table.

Answer 3

The formula will not automatically update when you change the values. Put the cursor in the formula's cell and press the F9 key and the formula will update and give the result. You could also create a macro to do it. For it to auto-update you could link to an Excel worksheet and make the changes in that, which will then be automatically updated.