Problem with Countif and And

[JohnTwo]

Hi all,

I expected the result to be 4. Why is it 0 instead? Thanks!

[#2 · Accepted solution]

you can't write an AND condition like that inside the COUNTIF. Use COUNTIFS instead: COUNTIFS(A1:A10;">3";A1:A10;"<8")

[#3]

Thank you!!