How to sum or count total for certain names in Jotform Tables?

  • JIJgadai
    Answered on June 03, 2021 11:21 PM

    In the form table/ submission, could i do some summary/ count the total from 1 name and how much he did? Like in the example from the screenshot, i want to automatic count how much rio earn from 2 submission and doesn't count how much other person did (not dio only rio).

    If i count it manually:

    Rio did 30k

    Dio did 100k.

    Can i get that kind of result in auto way? Is there any formula or way to get it?

    Jotform Thread 3139763 Screenshot
  • Jed_C
    Answered on June 04, 2021 07:26 AM

    You can filter the name so that it will only show the name you want to count. Kindly check my sample screencast below and see if that helps.

    1622806005 60ba0df5579c9 filter Screenshot 10

    Let us know if you have any questions or if you need further assistance.

  • JIJgadai
    Answered on June 05, 2021 01:13 AM

    1622781052 60b9ac7c102d4 Screen Shot 202 Screenshot 10