COUNTIF ... AND ... CONTAINS ...

Jessica Griffin

I am trying to count a source sheet if it's and new request and the Business area is HR

I have tried the following

=COUNTIF({Internal Comms Intake Range 2}, "New Request",({Internal Comms Intake Range 3},CONTAINS("HR",@cell))

Came back Unparseable

=COUNTIF({Internal Comms Intake Range 2}, "New Request", AND({Internal Comms Intake Range 3}, "HR"))

Came back Incorrect Argument Set

Find more posts tagged with

Accepted answers

Brett Wyrick

Hey Jessica - I think you're closer on your second formula.

Instead of COUNTIF and AND, just use COUNTIFS:

=COUNTIFS({Internal Comms Intake Range 2}, "New Request", {Internal Comms Intake Range 3}, "HR")

Report back and let me know if that works!

All comments

Brett Wyrick

Hey Jessica - I think you're closer on your second formula.

Instead of COUNTIF and AND, just use COUNTIFS:

=COUNTIFS({Internal Comms Intake Range 2}, "New Request", {Internal Comms Intake Range 3}, "HR")

Report back and let me know if that works!

Jessica Griffin

@Brett Wyrick That worked. Thank you!

Brett Wyrick

https://community.smartsheet.com/discussion/comment/310609#Comment_310609

Glad to help! Can you mark the "Answer" above as "Yes" so this shows as closed? Thanks!

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, latest, sort, sortType, lookupSort, discussion, discussion/name, tags, breadcrumbs, discussionApiParams, serverDraftID, serverDraft.