Need to count a set of numbers in a range
 

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.
--
thanks, Dave

Need to count a set of numbers in a range
 

On Sep 11, 12:08*pm, DaveC wrote:
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.
--
thanks, Dave

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

Need to count a set of numbers in a range
 

On Sep 11, 12:16*pm, jlclyde wrote:
On Sep 11, 12:08*pm, DaveC wrote:

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.
--
thanks, Dave

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

Need to count a set of numbers in a range
 

=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
--
Gary''s Student - gsnu200903


"DaveC" wrote:

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.
--
thanks, Dave

Need to count a set of numbers in a range
 

Excel 2007 -
=COUNTIFS(I3:I52,"=.09",I3:I52,"<=.11")
--
If this post helps click Yes
---------------
Peggy Shepard


"jlclyde" wrote:

On Sep 11, 12:16 pm, jlclyde wrote:
On Sep 11, 12:08 pm, DaveC wrote:

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.
--
thanks, Dave

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