Nested AND/OR statement with COUNTIF

deb_63_hydracor ✭✭✭✭✭✭
edited 06/21/22 in Formulas and Functions


I'm trying to count the number of rows that fit this criteria:

This is the formula I came up with but am getting an error. I'm betting that the problem is the placement of the ANDs?

=COUNTIF(AND((OR({Retail Survey Launch Status} = "Operational", {Data Upload Status} = "Operational",(AND({Experiencia Rounding Status}@row<>"Operational", {Experiencia Rounding Status}@row<>"Needs Post Launch Review", {Experiencia Rounding Status}@row<>"Post Launch Review Scheduled", {Experiencia Rounding Status}@row<>"Adding a Service", {Experiencia Rounding Status}@row<>"Requested Cancellation), {Monthly DataCor Revenue}, ""."")

Thanks for your help!



Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!