How can I get the total amount from our Material Costing and add automatically on our Job Analysis

Tyler Dickman

Hi, I have a Material Costing Sheet with our daily invoices that have different customer names and invoice amounts. I want to get the total of the invoice amounts per customer and auto-populate them on the Material Cost column under our Job Analysis Sheet.

bisaacs

Hey @Tyler Dickman,

You should be able to use the =SUM() function in the Job Analysis Sheet. If you want to reference data from a different sheet, click this link when typing the SUM function:

Then just select the whole column containing the invoice amounts and it should provide the sum.

Hope this helps!

Tyler Dickman

Hi, There are different names for each invoice and I want to match the amount with the same names. Is that possible?

Tyler Dickman

Is it supposed to be =SUMIFS(({Material Costing Per Customer Range 2}), MATCH({Material Costing Per Customer Range 3 "Customer", Column 1 "Customer Name}))?

I want to Match and sum all the invoices with the same customer name from another reference sheet to the job sheet.

Tyler Dickman

https://community.smartsheet.com/discussion/comment/437539#Comment_437539

Hi, There are different names for each invoice and I want to match the amount with the same names. Is that possible?

Is it supposed to be =SUMIFS(({Material Costing Per Customer Range 2}), MATCH({Material Costing Per Customer Range 3 "Customer", Column 1 "Customer Name}))?

I want to Match and sum all the invoices with the same customer name from another reference sheet to the job sheet.

Andrée Starå

https://community.smartsheet.com/discussion/122402/how-can-i-get-the-total-amount-from-our-material-costing-and-add-automatically-on-our-job-analysis

Hi,

I hope you're well and safe!

Here's the syntax and more details.

https://help.smartsheet.com/function/sumifs

It should look something like this. (Update column name and ranges to match yours)

=SUMIFS({Material Costing Per Customer Range 2}, {Material Costing Per Customer Range 3 "Customer"}, Customer@row)

Did that work/help?

I hope that helps!

Be safe, and have a fantastic weekend!

Best,

Andrée Starå | Workflow Consultant / CEO @ WORK BOLD

✅ Did my comment(s) help/answer your question or solve your problem? Please support the Community and me by marking it - Insightful 💡- Vote Up ⬆️ - Aweseome ❤️ - or/and as the accepted answer. It will make it easier for others to find a solution or help to answer! I appreciate it, thanks!