COUNTIFS based on conditions

SarahML ✭✭✭✭
edited 07/30/20 in Formulas and Functions

Hi I'm trying to count the number of teachers from different cohorts that have not yet given feedback through a form, so the cells with #NO MATCH.

I have all of the data in 1 SS and am totally and running metrics in another. In the sheet I'm running the metrics in I have a row for each cohort, and where I want the count to go.

In the sheet with the original data I have their individual information in the 1st 3 columns, their cohort, then their selection of a goal.

Here's what I've tried and I continue to get an unparseable error.

Range 2 is the cohort; Range 4 is Selected Goal.

=COUNTIFS({All Instructor Selection Range 2}, [Focus by Course]3, [{All AET Instructor PPG Selection Range 4}, "#NO MATCH"])



Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!