COUNTIFS+CONTAINS+AND

I am trying to write a sheet summary formula to count the number of rows where: Sprint Name contains "Maintenance", Date Resolved is not blank, and Bug or Request equals "Bug"

[Sprint Name]:[Sprint Name], CONTAINS("Maintenance")

and

[Date Resolved]:[Date Resolved], <>""

and

[Bug or Request]:[Bug or Request], "Bug"

I tried the following: =COUNTIFS([Sprint Name]:[Sprint Name], CONTAINS("Maintenance"), [Date Resolved]:[Date Resolved], <>"", [Bug or Request]:[Bug or Request], "Request") but I receive an #INCORRECT ARGUMENT SET error.

Find more posts tagged with

Formulas

Accepted answers

Carson Penticuff

CONTAINS() must include the range to compare. You can use @cell in this instance.

=COUNTIFS([Sprint Name]:[Sprint Name], CONTAINS("Maintenance", @cell), [Date Resolved]:[Date Resolved], <>"", [Bug or Request]:[Bug or Request], "Request")

All comments

Carson Penticuff

CONTAINS() must include the range to compare. You can use @cell in this instance.

=COUNTIFS([Sprint Name]:[Sprint Name], CONTAINS("Maintenance", @cell), [Date Resolved]:[Date Resolved], <>"", [Bug or Request]:[Bug or Request], "Request")

K Miller

Perfect. Thank you!!

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.