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


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!