Use COUNTIFS formula to count certain conditions by date column

Courtney Coules

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?

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

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!