Using COUNTIFS with multiple criteria and OR

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

Find more posts tagged with

Formulas

Accepted answers

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

All comments

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!

Sign in to join the conversation!

Quick Links

Component react.discussion.discussions had an error.

ref must be one of: categoryID, siteSectionID, category, category/categoryID, category/name, category/description, category/url, category/allowedDiscussionTypes, locale, siteSection, siteSection/basePath, siteSection/contentLocale, siteSection/sectionGroup, siteSection/sectionID, siteSection/name, siteSection/description, siteSection/apps, siteSection/attributes, layoutViewType, discussionID, commentID, page, sort, discussion, discussion/name, tags, breadcrumbs, discussionApiParams, serverDraftID, serverDraft.