As an example, we will total a column of decimal numbers. Open Word and put the cursor in the blank cell at the bottom of the column that has the numbers you want to sum. The correct formula is automatically inserted into the Formula edit box on the Formula dialog box. I selected 0. Depending on your data, you can pick a different number format. The formula field is inserted into the cell and the total is automatically calculated and displayed. If you change any of the numbers in the Amount column, right-click on the total and select Update Field from the popup menu to update the total.
You can also press F9 while a field is selected to update it. There is one big caveat when using formulas like this in Word. The data should all be contiguous, meaning there should be no breaks in the data. For example, take a look at the data below.
For the month of March, there is no data in the second column. Now if I put a 0 in the cell and update the field, then it gives me the correct answer I was looking for. Obviously, keep this in mind and check your the results to make sure they are correct. This feature is available in Word, but it is not on any of the ribbon tabs.
To have access to it, you must add it to the Quick Access toolbar. To do this, click the Office button and click the Word Options button. Susan Sales Harkins is an IT consultant, specializing in desktop solutions. Previously, she was editor in chief for The Cobb Group, the world's largest publisher of technical journals.
Word can add! Seriously, if you're using Word and you need a few basic calculations, you don't have to insert an Excel sheet. You can use a Word table and let Word do the calculating. The feature's limited, but it's perfectly capable of the basics.
AutoSum seems to be absent from Word , but you can still insert formulas. First, Word uses table cell coordinates to determine the values it evaluates.
Notice that the table below has an empty column to the right and an empty row at the bottom. That's where we'll perform calculations on the existing values. Simply click in a cell to the right or below a contiguous row or column and click the AutoSum button on the Tables And Borders toolbar. For example, to sum the units sold in the north by all representatives, click the blank cell just below those values and to the right of the Total row's heading cell and click AutoSum.
As you can see, the total number of units for the north is AutoSum automatically summed all of the values above the current cell.
It will stop at an empty cell. To total the units sold by Harkins all four regions , click inside the empty cell at the far right of the Harkins row, just under Total, and click AutoSum. This time, AutoSum determined that the values were to the left. Unfortunately, the above did not work w hen I tried to add my column of figures. The best that came up was the sum of 2 in the cell immediately above. I have previously used the autosum as well as formulas in other documents, and everything worked just fine.
I am really stymied and have wasted a lot of time on this when I just should have added the numbers in my head! Can I reference another cell in a functions, like in Excel. I want to enter a date then have each successive date change.
Is this possible? A2 represents the cell that I would enter a date. In word Im trying to get this chart to do averages and keep getting Syntex errors.
Sum — format. How do I see the answers to the questions in this forum? You did what my college prfoessor and college book couldnt tell me to do in an hour, in just a few seconds. Thank im tired of this world overcomplicating shit. Useful article! But I need an autosum — that recalculates the sum if one of the values changes.
Not very useful without that feature. On the right side, you can add a new group where ever you want the Sum button to go. I just make a Sum entry in my main tab section. Great — but how do I give it a title, that I can then reference in for example a list of tables. Great info. Can nested formulas be used in Word tables to conditionally set the content of a table cell?
0コメント