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?

Co

Paul Newcome

There are two ways to do this depending on which list is shorter. Those to Exclude or Those to Include.

Exclude List:

=COUNTIFS(Route:Route, AND(@cell <> "A", @cell <> "B", @cell <> "C"))

Include List:

=COUNTIFS(Route:Route, OR(@cell = "D", @cell = "E", @cell = "F"))

SkiPatrolScott

Thanks @Paul Newcome , I will try one of those options, better then my current solution..

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

Paul Newcome

Happy to help. 👍️

Paul Newcome

There are two ways to do this depending on which list is shorter. Those to Exclude or Those to Include.

Exclude List:

=COUNTIFS(Route:Route, AND(@cell <> "A", @cell <> "B", @cell <> "C"))

Include List:

=COUNTIFS(Route:Route, OR(@cell = "D", @cell = "E", @cell = "F"))

SkiPatrolScott

Thanks @Paul Newcome , I will try one of those options, better then my current solution..

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

Paul Newcome

Happy to help. 👍️