Formula to count $ amount for specific vendor

I am creating a dashboard to show my department's metrics. I have tried multiple formulas but keep getting errors. I need to calculate how much was spent for a specific vendor. I am using a reference sheet in the formula with the range being "vendor" but I cannot figure out the proper criterion to count the $ in a different column.

EX: If the vendor is Simon Roofing, how much $ invoiced overall.



Answers

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!