Count Values In One Column Based on Values Of Another Column


I have 2 columns:

  1. Client (containing names of my clients)
  2. Status (containing the status of the client)

I need a formula that counts the clients in Column 1 that don't have a status of Lost in Column 2.

I have tried with CountIfs and Not(Contains) but with no luck



Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!