COUNTIFS based on conditions
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
-
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.
-
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!
-
Happy to help. 👍️
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Customer Resources
- 64.9K Get Help
- 439 Global Discussions
- 138 Industry Talk
- 470 Announcements
- 4.9K Ideas & Feature Requests
- 129 Brandfolder
- 148 Just for fun
- 67 Community Job Board
- 486 Show & Tell
- 33 Member Spotlight
- 2 SmartStories
- 300 Events
- 36 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!