Skip to main content
Question

Summing Costs from Multiple Rows and Columns

  • May 16, 2019
  • 0 replies
  • 29 views
May I ask for advice on creating a formula to add costs from two columns and multiple rows?

I'm importing a report and calculating the two Cost columns. I need to add the Model Material Cost and Support Material Cost to get the Total Cost for Job. The image below shows report. I'm not sure which function would work to do that for each job. This is my first QB app. Thank you.



    This topic has been closed for replies.

    no problem,

    You can make a new field called 

    Total Cost 

    as a formula numeric field.

     The formula would be

    [Model Material Cost] + [Support Material Cost]
    • TimLivermon
    • Author
    • Registered
    • May 16, 2019
    Thank you for the quick response. I tried to paste an image of the report showing the report fields I need to add with the original question but it didn't show up. I'll try to paste again below. The material types have different costs so I can't use the total which is 1992 for the first job. That comes the the program that generates the imported file. The Total Cost formula would add the 3 Model Material Costs to to the Support Material Cost for the first Job and then go to the next Job. 



    Thanks again.
    Terms & ConditionsAccessibility statement