Using COUNTIFS with multiple criteria and OR



I'm trying to count the number of rows that meet the following criteria (I'm getting an "Incorrect Argument" error.

  • Project Complete is not checked
  • Project Cancelled is not checked
  • Sales & Leads is not checked
  • Month is August
  • Year is 2022
  • Deployment Type is either New Deployment or Package Upgrade

=COUNTIFS({Project Complete}, 0, {Project Cancelled}, 0, {Sales & Leads}, 0, {Month}, @cell = 8, {Year}, @cell = 2022, {Deployment Type}, OR(@cell = "New Deployment", @cell = "Package Upgrade"))


Best Answer


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!