How to sum the values in a column?

  • kofrockets
    Answered on February 28, 2021 12:35 PM

    Please help!

    I am creating a simple inventory form which asks how many of each item they have.

    But how can I get the totals (sum) from each column under all the responses for each question? For example, if I ask all the responders "how many of item A do you have?", I would like the Excel sheet to tally everyone's responses to that question at the bottom of the column. Same with all the columns.

    It is great to see all the answers to the questions. But I need to see the responses aggregated and the totals reported. Also, is there a way to turn that summed up data into graphs and charts?

    Thank you!

  • Welvin Support Team Lead
    Answered on February 28, 2021 05:11 PM

    I'm sorry, but we do not have a feature that can sum up the answers in a column of a submissions/tables page. A workaround is to download the submissions as Excel and sum up the columns manually.