how to get a total of all orders

  • Profile Image
    Asked 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. 

  • Profile Image
    Answered on March 25, 2015 at 06:46 PM



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


    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:

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