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