SUM a column if another contains value


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!

Best Answer

  • Nic Larsen
    Nic Larsen ✭✭✭✭✭✭
    edited 01/07/21 Answer ✓

    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.


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!