COUNTIF with multiple criteria
Hi, I am trying to create a function to count the number of times we got a certain response, i.e. "very poor" separately based on which stage of studies a student is on (separate column). So I want my countif to pull from 2 columns (educaitonal materials and step). Here is the formula I made, but I keep getting an error. Any suggestions?
=COUNTIF([Educational Materials]:[Educational Materials], "Very Good", [Step]:[Step], "Step 1")
Answers
-
Use COUNTIFS function for multiple conditions.
-
I tried CountIfS, but I always get unparseable =COUNTIFS([BTA Deployment Status]:[BTA Deployment Status], "Out of Scope",([BTA Deployment Status]:[BTA Deployment Status] "Dynamify Ready"))
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Customer Resources
- 66.1K Get Help
- 430 Global Discussions
- 149 Industry Talk
- 489 Announcements
- 5.2K Ideas & Feature Requests
- 85 Brandfolder
- 154 Just for fun
- 74 Community Job Board
- 499 Show & Tell
- 33 Member Spotlight
- 2 SmartStories
- 305 Events
- 36 Webinars
- 7.3K Forum Archives
Want to practice working with formulas directly in Smartsheet?
Check out the Formula Handbook template!
Check out the Formula Handbook template!