Use COUNTIFS formula to count certain conditions by date column

I want to use COUNTIFS formula to count the number of program participants who have received treatment and did not have a confirmed home plan by their specific release date. This is the formula I have so far:

=COUNTIFS({Assessment and Intake Tracking_MAT Prison Range 11}, "Yes", COUNTIFS({Assessment and Intake Tracking_MAT Prison Range 13}, @cell < TODAY(), {Assessment and Intake Tracking_MAT Prison Range 28}, 0))

This is giving me error message: "INCORRECT ARGUMENT". How can I fix this formula to calculate what I need?

Find more posts tagged with

Accepted answers

Kelly Moore

Hey @Courtney Coules

This formula below has corrected syntax

=COUNTIFS({Assessment and Intake Tracking_MAT Prison Range 11}, "Yes", {Assessment and Intake Tracking_MAT Prison Range 13}, @cell < TODAY(), {Assessment and Intake Tracking_MAT Prison Range 28}, 0)

Will this work for you?

Kelly

All comments

Kelly Moore

Hey @Courtney Coules

This formula below has corrected syntax

=COUNTIFS({Assessment and Intake Tracking_MAT Prison Range 11}, "Yes", {Assessment and Intake Tracking_MAT Prison Range 13}, @cell < TODAY(), {Assessment and Intake Tracking_MAT Prison Range 28}, 0)

Will this work for you?

Kelly

Courtney Coules

It seems to be working, thanks so much!

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.