SUM a column if another contains value

Xenia Tulupova

I'm trying to figure out how to count the sum of a column if another column contains a specific keyword. I have a list of vendor names that have been paid, how can I count the balance by vendor? Thanks!

Nic Larsen

Columns with a space [Vendor Name] need brackets versus columns with a single word Vendors. You shouldn't need @cell reference, in this case either.

Nic Larsen

Something like this: =SUMIFS([Vendor Charges]:[Vendor Charges], [Vendor Name]:[Vendor Name], "Vendor A")

Xenia Tulupova

Pretty close, this is what worked: =SUMIFS([Paid Amount]:[Paid Amount], Vendor:Vendor, @cell = "Vendor X") However, it I remove the [ ] the formula doesn't work.

It does work without the brackets in an identical formula for balance past due. What gives?

Nic Larsen

Columns with a space [Vendor Name] need brackets versus columns with a single word Vendors. You shouldn't need @cell reference, in this case either.

Xenia Tulupova

OK makes sense, thanks!