using count if to count a range within a range

[kyoung22]

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

 

[Joe4]

WELCOME TO THE BOARD!

When you have more than one condition, a single COUNTIF statement will not work. You can use SUMPRODUCT when you have multiple conditions:

=SUMPRODUCT((Q6:Q3067>0)*(Q6:Q30670<2))

 

[kyoung22]

WOW - Thanks so much! I am sure you knew that it would work but YEA - it worked!!

Kim

WELCOME TO THE BOARD!

When you have more than one condition, a single COUNTIF statement will not work. You can use SUMPRODUCT when you have multiple conditions:

=SUMPRODUCT((Q6:Q3067>0)*(Q6:Q30670<2))