COUNTIF with multiple criteria

EGarcia

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

Sameer Karkhanis

Use COUNTIFS function for multiple conditions.

Jeannie Peirce

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