COUNTIFS based on conditions

SarahML

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"])

TIA

Paul Newcome

You have an extra square bracket tucked in after your last criteria.

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

SarahML

It's still not working after removing that bracket.

Paul Newcome

My apologies. I missed the other square bracket before the second range. Here...

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

SarahML

Now I'm getting Incorrect Argument.

SarahML

Nevermind, finally got it to work. After changing up the range selection and using those tips it finally worked. Thanks!

Paul Newcome

Happy to help. 👍️