What is JotForm?
JotForm is a free online form builder which helps you create online forms without writing a single line of code. No sign-up required.

At JotForm, we want to make sure that you’re getting the online form builder help that you need. Our friendly customer support team is available 24/7.

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.


  • Profile Image

    How to Add up the Cell Values of Matrix Table to another Cell Value

    Asked 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

    stats Matrix Grid add value cell value
  • Profile Image
    JotForm Support

    Answered by jonathan on October 13, 2015 at 10:21 PM

    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.

     

     

  • Profile Image
    JotForm Support

    Answered by jonathan on October 13, 2015 at 10:23 PM

    Another option you may want to check is using the Spreadsheet Widget

    link: http://widgets.jotform.com/widget/spreadsheet

    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.

     

    Thanks.