Count cells between two numbers

[SamanthaKorenel]

Hello, i have an cell with values, 1 value means that the student passed, and 0 means that he failed. So in another cell i want to count how many students failed and how many passed?

 

[JamesLoft]

Hello, you should use Countif formula. =COUNTIF(A:A, ">1").

 

[SamanthaKorenel]

Thank you!! Just needed to change that ">1" to ">0".

 

[Tetra201]

Hello, you should use Countif formula. =COUNTIF(A:A, ">1").

Rather =COUNTIF(A:A,1)

 

[SamanthaKorenel]

Thank you!

 

[Tetra201]

You are welcome.