Countifs, is not blank question??

I have a formula that counts distinct entry's in a column "IFS Service Location" (to avoid counting duplicates) and in the "booking status" column had a status of "ready to book". .

=COUNT(DISTINCT(COLLECT({IFS Service Location ID}, {Booking Status}, "Ready to Book")))

I would like to change the citerion_range1 to a different column called "incentive date" and count the non blank cells in that column.

=COUNTIFS(DISTINCT(COLLECT({IFS Service Location ID}, {Incentive Date}, <>"" )))) (unparseable)

It does not work yet. Am I on the right track? Any suggestion would be appreciated.

Find more posts tagged with

Accepted answers

All comments

TDobson

Here is a snipit of the 2 columns. The Incentive Date column is a date column.

Genevieve P.

Hi @TDobson

It looks like you just have an extra closing parentheses!

=COUNT(DISTINCT(COLLECT({IFS Service Location ID}, {Incentive Date}, <>"" )))

You only need three ))) one for COUNT, one for DISTINCT, one for COLLECT. Let me know if updating the COUNTIFS to COUNT and removing one ) from the end works for you.

Cheers,

Genevieve

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.