Struggling to String together the correct COUNTIFS

Options

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

Tags:

Answers

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!