Count IFS

I am trying to build a formula that will count the number first based one the COE name, then to give a number on each disposition status. I thought it would be something like:

=COUNTIF({Policy Project Status Report Range 3}, "Global Rewards"),({Policy Project Status Report Range 1}, "Keep/Enterprise")

=COUNTIFS([Assigned To]:[Assigned To], "Global Rewards"), AND([Document Disposition Status]:[Document Disposition Status], "Keep/Enterprise"))

But that isn’t working.

Find more posts tagged with

Formulas

functionality

Accepted answers

All comments

Paul Newcome

You don't need the AND statement in your COUNTIFS and it is all one function so no need for the early closing parenthesis.

=COUNTIFS([Assigned To]:[Assigned To], "Global Rewards", [Document Disposition Status]:[Document Disposition Status], "Keep/Enterprise")

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.