countif numbers between 60 and 70

[INN]

Hi

I want to write a formula to cound how many students markes between 60 and 70. So I wrote this formula but did not work

=COUNTIF(A2:A6,AND(">60","<80"))

Thank you very much

Student Marks

90​

77​

96​

94​

29​

45​

 

[AhoyNC]

try

=COUNTIFS(A2:A6,">60",A2:A6,"<80")

 

[INN]

Never thought of Countifs. I did work fine. Thank you so much for the help. I appreciate it.

 

[AhoyNC]

You're welcome. Thanks for the feedback.