M
mtaystl11
I am trying to get a "Countif" function to count within a certain
number. Meaning, I need to get it to count how many cells are between
the number 5 and 10.
I understand that you can put
=countif(A31:A42, >32) or
=countif(A31:A42, <32) or
=countif(A31:A42, "32"
but how do I do the 5 through 10?
I have tried
=countif(A31:A42, 5-10) DIDNT WORK
=countif(A31:A42, "5-10") DIDNT WORK
=countif(A31:A42, 5;6;7;8;9;10) DIDNT WORK
I would really appreciate some help here. I'm sure it is a simple fix
but I just can't figure it out! THANKS!
number. Meaning, I need to get it to count how many cells are between
the number 5 and 10.
I understand that you can put
=countif(A31:A42, >32) or
=countif(A31:A42, <32) or
=countif(A31:A42, "32"
but how do I do the 5 through 10?
I have tried
=countif(A31:A42, 5-10) DIDNT WORK
=countif(A31:A42, "5-10") DIDNT WORK
=countif(A31:A42, 5;6;7;8;9;10) DIDNT WORK
I would really appreciate some help here. I'm sure it is a simple fix
but I just can't figure it out! THANKS!