Count if distinct and if meets set criteria

I am trying to count unique rows if certain information is met.

For example, one of the formulas I have written is =COUNTIFS({PledgeAmountSummary2022 Range 1}, Campaign@row, {PledgeAmountSummary2022 Range 4}, Division@row). This works until I try to add the stipulation of only counting unique data based on another column within the same reference sheet.

Can someone help me set this formula up correctly? I have tried a number of times and a number of ways and keep getting errors.

Find more posts tagged with

Accepted answers

Dale Murphy

@Erica Maynard

This formula counts unique dates in the column Schedule date that meet the condition of being older (les than) today. (change the row numbers to @row to expand it)

=COUNT(DISTINCT(COLLECT([Schedule date]39:[Schedule date]47, [Schedule date]39:[Schedule date]47, <TODAY())))

You should be able to use those functions within your formula.

All comments

Dale Murphy

@Erica Maynard

This formula counts unique dates in the column Schedule date that meet the condition of being older (les than) today. (change the row numbers to @row to expand it)

=COUNT(DISTINCT(COLLECT([Schedule date]39:[Schedule date]47, [Schedule date]39:[Schedule date]47, <TODAY())))

You should be able to use those functions within your formula.

Erica Maynard

@Dale Murphy, Thank you but I am not looking at a date. I am trying to count the number of unique donations for each location and each campaign that we have.

Dale Murphy

The principle should apply. Instead of doing a distinct collect on date, use whatever is unique about the donation row. (Is there an id or registration number of some kind?)

Erica Maynard

That worked! Thank you @Dale Murphy

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.