COUNTIFS based on conditions

07/30/20 Edited 07/30/20
Answered - Pending Review

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



Answers

  • Paul NewcomePaul 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")

  • It's still not working after removing that bracket.

  • Paul NewcomePaul 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")

  • Now I'm getting Incorrect Argument.

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

  • Paul NewcomePaul Newcome ✭✭✭✭✭

    Happy to help. 👍️

Sign In or Register to comment.