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"))
Tags:
Best Answer
-
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
-
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"))
-
Thanks Mike. It worked!
Help Article Resources
Categories
Want to practice working with formulas directly in Smartsheet?
Check out the Formula Handbook template!
Check out the Formula Handbook template!