Summing Costs from Multiple Rows and Columns
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 S...
Forum Discussion
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.
Thanks again.