What is JotForm?
JotForm is a free online form builder which helps you create online forms without writing a single line of code. No sign-up required.

At JotForm, we want to make sure that you’re getting the online form builder help that you need. Our friendly customer support team is available 24/7.

We believe that if one user has a question, there could be more users who may have the same question. This is why many of our support forum threads are public and available to be searched and viewed. If you’d like help immediately, feel free to search for a similar question, or submit your question or concern.


  • Profile Image

    how to get a total of all orders

    Asked by ptg on March 25, 2015 at 05:32 PM

    I used the purchase order which does a great job of getting the total of the items that are ordered. Now i want a total of all purchases done. I can download to excel but do not know how to total the costs. The field has costs for each item ordered and a total cost for the order but not for all the orders. 

    Page URL:
    http://form.jotform.us/form/50775625387163

    all
  • Profile Image
    JotForm Support

    Answered by david on March 25, 2015 at 06:46 PM

    Hi,

    =SUM(D2:D4)

    If all your values are numerical, you can add an a formula such as this to a cell in your spreadsheet:

    =sum(d1:d5)

    This would add up all the values in cells d1-d5 in a spreadsheet and give you the total in the cell in which it is entered.  Tailor the formula to match your sheet.  The autosum feature in Excel should also be able to do this:

    https://support.office.com/en-za/article/Use-AutoSum-to-sum-numbers-543941e7-e783-44ef-8317-7d1bb85fe706

    If you have any further questions, let us know and we will be happy to help.