How to sum the values in a column?

  • Profile Image
    Asked on February 28, 2021 at 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!

    This is a re-post of a comment on How to Create an Excel Report

  • Profile Image
    Answered on February 28, 2021 at 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.