How do I sum a grid column? ListSum isn't working for me and the instructions say it's only for Series answers. I can't use the MS Word sum  function either. I just want to assign the sum of a grid column to a derived answer and use it as a field in the document. Couldn't find an answer in the manual either. Am I doing something wrong?

Answer:

This form illustrates a way to determine the Sum of specific discrete items in a GRID. 
In this case, the GRID lists two people and the individual debts each owes. The task is to organize and show the debts in the form, then the magic part, show the total payments due from each.
 

We used Derived Answers in the Questionnaire to create a Sublist of the payments for each Party. In the Form we used a List of all the Debts showing the Creditors, the cause of the debt, the Balance, Payment, and the Party responsible for the Debt. 
 

Completely unrelated to that Table, we manually created a two-column, two row table with fixed text in the first column and a Field in each row in the second column. The Field is a Math computation using a Derived Sum function drawing on the Sublist of payments in the Derived Answer for each Party in the Questionnaire.
 

This is a link to the Word document illustrating and demonstrating the solutions, including the appropriate commands.

https://static.helpjuice.com/helpjuice_production/uploads/upload/image/12553/direct/1749855891881/Sublists%20GRIDS%20Derived%20Answers%2C%20OK%20Divorce.docx