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

  • Profile Image
    Asked 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

  • Profile Image
    Answered 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
    Answered on October 13, 2015 at 10:23 PM

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


    here is the demo form

    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.