Nested AND/OR statement with COUNTIF

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

Hello,

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!

Tags:

Answers

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!