Modify a COUNT(DISTINCT(COLLECT to a COUNTIF(DISTINCT(COLLECT

So I have this formula which works fine.

=COUNT(DISTINCT(COLLECT({FPR24-INSTALLER}, {FPR24-INSTALL DT}, =Date@row, {FPR24-INSTALL DT}, =(Date@row))))

I want to change it to a COUNTIF but I can't get it to work.

=COUNTIF(DISTINCT(COLLECT({FPR24-INSTALLER}, {FPR24-INSTALL DT}, =Date@row, {FPR24-INSTALL DT}, =Date@row)), {FPR24-Res/Com}, "Res")

It's probably something simple, but I can't figure it out. Any help would be appreciated. Thank you...

Find more posts tagged with

Formulas

Accepted answers

Paul Newcome

You wouldn't use a COUNTIF. You would just stick with the COUNT and include the additional range/criteria sets in the COLLECT function.

All comments

Paul Newcome

You wouldn't use a COUNTIF. You would just stick with the COUNT and include the additional range/criteria sets in the COLLECT function.

tgattsh

@Paul Newcome Thanks Paul, that worked just fine. Just over thinking it I guess...

Paul Newcome

Happy to help. 👍️

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.