Struggling to String together the correct COUNTIFS

Garry McEwen

Hello There Community

I need help with stringing variables together

I am using the following formula: =COUNTIFS({GDS}, "Sabre", {Status}, "Open", {Airline}, (CONTAINS ("AA", (OR ("ALL")))))

Everything works up until {Airline} which is the sheet reference

Essentially I want to return the count if the cell contains either AA or ALL or Both

Currently getting unparseable.

Help is greatly appreciated.

Thanks

Garry

Paul Newcome

Try this instead:

=COUNTIFS({GDS}, "Sabre", {Status}, "Open", {Airline}, OR(CONTAINS ("AA", @cell), CONTAINS("ALL", @cell)))

Garry McEwen

@Paul Newcome

Copied and pasted - =COUNTIFS({GDS}, "Sabre", {Status}, "Open", {Airline}, OR(CONTAINS ("AA", @cell), CONTAINS("ALL", @cell)))

Cell still comes back Unparseable 😫

Garry McEwen

Have managed to fix it

=COUNTIFS({GDS}, "Sabre", {Status}, "Open", {Airline}, OR(@cell = "AA", @cell = "ALL"))