How do I automate adding up a column of numbers in a Word template

[Terri]

I am created a template to record the scores of my students on an assignment.
The scores for each part of the assignment are entered in a form field in a
cell in a column, then I want to add all the scores and show the results at
the bottom of the column. I have inserted a text form field with calculation
and the formula (=SUM(ABOVE). I want to automate the calculation so when I
enter the scores in the field, the total will appear when all the scores are
entered in the fields. So far I can only do the calculation when I right
click on the field and select update. What can I do to automate this?

 

[Beth Melton]

I am created a template to record the scores of my students on an
assignment.
The scores for each part of the assignment are entered in a form field in
a
cell in a column, then I want to add all the scores and show the results
at
the bottom of the column. I have inserted a text form field with
calculation
and the formula (=SUM(ABOVE). I want to automate the calculation so when I
enter the scores in the field, the total will appear when all the scores
are
entered in the fields. So far I can only do the calculation when I right
click on the field and select update. What can I do to automate this?

You should really use Excel and not Word. As you found it doesn't
recalculate and as you may find, =Sum(Above) doesn't always work as
expected. For example it will stop calculating at the first empty cell in
the column. That's not a "good thing" when dealing with student grades. ;-)

--
~~~~~~~~~~~~~~~
Beth Melton
Microsoft Office MVP
https://mvp.support.microsoft.com/profile/Melton
What is a Microsoft MVP? http://mvp.support.microsoft.com/gp/mvpfaqs

Guides for the Office 2007 Interface:
http://office.microsoft.com/en-us/training/HA102295841033.aspx

 

[SMAW-CPR]

By the sounds of it, you want to create a spreadsheet that calculates
averages. You could easily use excel, and creat a spreadsheet that calculates
the marks. If you do a search on the office site; under templates, and look
for a grade sheet or something like that, that should be what you want.

 

[CremeStout]

Excel is the way to go, and there are some templates, found in the tracking
area for templates that might be exactly what you want.

However, until you find them!
Below the last score enter =sum(b1:b15) so for 15 students listed in column
A you would find the total score.

Column A B
student name score

Below that formula to get Avg =Average(B1:B15)

So if you want to list all the test scores for each student across (many
ways to copy column) (hint for me I like to click on top box drag to last
entry (avg), release cursor, then while highlighted click on lower right
corner then drag horizontally).

This is real basic.
Once you get going based on the avg score you can do things like "IF, Then
,Else" formula to stack rank ,assign grades, Excel is the way to go.
good luck.