I am having an issue using the countif feature.
What I would like to do is a count of a range but count if a number is greater that one number and less than another number.
I started this way:
=countif(Q6:Q3067, ">0<2")
Can I ask it to count if a number is between two numbers like this?
This seems like it sould be easy enough to do, what am I overlooking?
Any suggestions/solutions whould be greatly appreciated.
Kim
What I would like to do is a count of a range but count if a number is greater that one number and less than another number.
I started this way:
=countif(Q6:Q3067, ">0<2")
Can I ask it to count if a number is between two numbers like this?
This seems like it sould be easy enough to do, what am I overlooking?
Any suggestions/solutions whould be greatly appreciated.
Kim