Count that excludes blanks

I have the formula below that works perfectly, but I want it to exclude anything in the column "Phase Gate Criteria Identifier" that is blank. Can anyone help add that in? thanks!!

=COUNTIFS([Stage-Gate Category]:[Stage-Gate Category], "Planning & Resourcing", Header:Header, 0, [Current Phase?]:[Current Phase?], 1, [Phase Gate Criteria Identifier]:[Phase Gate Criteria Identifier], <>"")

Find more posts tagged with

Accepted answers

All comments

Michael Culley

It looks like you did it correctly to me. Is it not giving you the results you're looking for?

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.