How do I get an input table to sum the values in a column?

  • Profile Image
    Asked on August 27, 2017 at 12:28 AM

    In my Fight Like Allen T-Shirt Order Form, I have an input table that I don't know how to make calculate the numbers in the column for the quantity of t-shirts being ordered for each type.

  • Profile Image
    Answered on August 27, 2017 at 03:14 AM

    Here is how you can do that:

    You can use condition "if the input table is filled" and then sum all shirts for that price, multiply with price and place the result in the appropriate column. Like in the image above. The same you do for other two, you sum their columns and put the result in the appropriate column sum.

    And here is how it works:

    If you need just to calculate the number of shirts (without the price) then just remove the multiplying from the calculation.

     Here is my test form feel free to check:

    Let us know how it worked.

    Thank you!

  • Profile Image
    Answered on August 27, 2017 at 10:43 AM
    That's exactly what I need - can you save that form to my account? I couldn't see how to. Thanks!
  • Profile Image
    Answered on August 27, 2017 at 12:02 PM

    You can clone that form in your account as shown on this guide: