JotForm is a free online form builder which helps you create online forms without writing a single line of code. No sign-up required.
We believe that if one user has a question, there could be more users who may have the same question. This is why many of our support forum threads are public and available to be searched and viewed. If you’d like help immediately, feel free to search for a similar question, or submit your question or concern.
How to Add up the Cell Values of Matrix Table to another Cell ValueAsked by coachlee on October 13, 2015 at 05:06 PM
Id like to add up the values inserted in 3x fields and display it in a forth for each row of a matrix grid.
Im basically creating a stat sheet which i can embed to my basketball club's website to allow team admin members to enter stats of their game scoresheets.
This is a re-post of a comment on Form Calculation - Math Function Reference
Unfortunately it cannot work that way. It is not possible yet to use the specific Matrix cell as the recipient of Calculation results.
What you can do at this time is to use another separate field (Textbox will do), as the target container for the result.
Here is an example on what I meant
Let us know if you need further assistance.
Another option you may want to check is using the Spreadsheet Widget
here is the demo form http://form.jotformpro.com/form/51730795061960?
If you test the form, you can see that it was able to calculate values of the cell and display the result on another cell within the spreadsheet.