Excluding multiple options from a COUNTIF..., istext@cell

SkiPatrolScott ✭✭✭✭

I have a column where I want to count any entry which I used a , istext(@cell), however now there are entries that I want to exclude, I used the formula below for my Sheet Summary 'Count of Routes'

=COUNTIF(Route:Route, ISTEXT(@cell)) - COUNTIF(Route:Route, "AVA IC / Dispatch")

But now I am getting additional entries that I need to not count, "Grabb", "SIT Safety" there will probably be more. Is there a way to group all of the exclusions?


Best Answers


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!