Formula to count $ amount for specific vendor

Bhawkins

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.

Eric Law

@Bhawkins Try =SUMIF(Vendor:Vendor, "Simon Roofing", Amount:Amount) Replace Simon Roofing with whatever vendor you want