Using COUNTIFS with multiple criteria and OR

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

Mike TV

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

Mike TV

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

deb_63_hydracor

Thanks Mike. It worked!