Need to count a set of numbers in a range

[DaveC]

I have a range of numbers, I3:I52 that contain percentages.
I need to count the number of cells that are between 9% and 11%.
I have tried multiple COUNTIF statements but that doesn't seem to work.
Any help is appreciated.

 

[jlclyde]

I have a range of numbers, I3:I52 that contain percentages.
I need to count the number of cells that are between 9% and 11%.
I have tried multiple COUNTIF statements but that doesn't seem to work.
Any help is appreciated.

This is how to do it with Count if.
=COUNTIF(A1:A10,"<="&.11)-COUNTIF(A1:A10,"<="&.09)

Here is how to do it with Sumproduct
=SUMPRODUCT((A1:A10<=.11)*(A1:A10>=.09)*(1))

Jay

 

[jlclyde]

This is how to do it with Count if.
=COUNTIF(I3:I52,"<="&.11)-COUNTIF(I3:I52,"<="&.09)

Here is how to do it with Sumproduct
=SUMPRODUCT((I3:I52<=.11)*(I3:I52>=.09)*(1))

Jay

This is with your range.
This is how to do it with Count if.
=COUNTIF(I3:I52,"<="&.11)-COUNTIF(I3:I52,"<="&.09)

Here is how to do it with Sumproduct
=SUMPRODUCT((I3:I52<=.11)*(I3:I52>=.09)*(1))

Jay

 

[pshepard]

Excel 2007 -
=COUNTIFS(I3:I52,">=.09",I3:I52,"<=.11")

 

[Gary''s Student]

=SUMPRODUCT((I3:I52>=0.09)*(I3:I52<=0.11))
so for data like:

19.00%
1.00%
18.00%
6.00%
6.00%
8.00%
11.00%
10.00%
19.00%
12.00%
9.00%
3.00%
8.00%
19.00%
5.00%
18.00%
6.00%
3.00%
12.00%
18.00%
5.00%
13.00%
18.00%
16.00%
3.00%
9.00%
13.00%
12.00%
3.00%
20.00%
11.00%
2.00%
4.00%
6.00%
9.00%
7.00%
19.00%
2.00%
20.00%
11.00%
7.00%
9.00%
15.00%
13.00%
10.00%
5.00%
6.00%
10.00%
18.00%
8.00%

the formula yields 10