Excluding multiple options from a COUNTIF..., istext@cell
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?
Help Article Resources
Check out the Formula Handbook template!