Issue with CountIFs function

Hi all i'm currently attempting to use a COUNTIF function to count with 3 conditions. However my output comes up with 0 when there are more than 0 items that meet the criteria. Can anyone assist to see if my formula is incorrect?

=COUNTIFS({Type}, HAS({Type}, "Storyline"), {Current Maintenance Assignee}, "Earl Prentice", {Production Status}, "Live")

Find more posts tagged with

Formulas

IT & Operations

Accepted answers

All comments

Dale Murphy

@Earl P

I don't think you need the HAS clause. Try COUNTIFS({Type}, "Storyline", {Current Maintenance Assignee}, "Earl Prentice", {Production Status}, "Live")

Or, replace HAS({Type} with HAS(@cell) - that also seems to work but is more complicated.

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.