Using COUNTIFS with multiple criteria and OR

deb_63_hydracor
deb_63_hydracor ✭✭✭✭✭✭

Hi,

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"))

Tags:

Best Answer

  • Mike TV
    Mike TV ✭✭✭✭✭✭
    Answer βœ“

    @deb_63_hydracor

    Does this work?

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

Answers

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!