Frequency of a range

[zipzip]

Please, I have a list of numbers, eg. : ( I8:I507 )
I need to know the frequency of a range at this list of numbers.
That range is at C1 and C2 Cells, eg.: ( C1 = 1 and C2 = 13 ), so (
1,2,3,.....,13).

I used =COUNTIF(I8:I507;C1) , but I need to reach the range, not only one
value.
Is there a way to to this ?
Using >C1 and <C2 ?

Thanks
Renê

 

[Bob Phillips]

=SUMPRODUCT(--(I8:I507>C1),--(I8:I507<C2))

--

HTH

RP
(remove nothere from the email address if mailing direct)

 

[CLR]

You might want to check out Tools > data Analysis >
Histogram...............you can build a BIN (list) of your 1 to 13 numbers
and get a distribution........how many hits on each number............

Vaya con Dios,
Chuck, CABGx3

 

[et]

Hi Bob,

Could you teach me what is the difference between

=SUMPRODUCT(--(I8:I507>C1),--(I8:I507<C2))
and
=SUMPRODUCT((I8:I507>C1)*(I8:I507<C2))

Thanks
Eling

 

[Bob Phillips]

Eling,

The result is the same, it is just a different way to get to it. There is a
full explanation at http://www.xldynamic.com/source/xld.SUMPRODUCT.html
which hopefully explains why I prefer --.

--

HTH

RP
(remove nothere from the email address if mailing direct)

 

[et]

Thankyou, Bob.

Eling,

The result is the same, it is just a different way to get to it. There is
a
full explanation at http://www.xldynamic.com/source/xld.SUMPRODUCT.html
which hopefully explains why I prefer --.

--

HTH

RP
(remove nothere from the email address if mailing direct)

 

[zipzip]

Please, is there at Excel 2000 ?
I could not find it.
Regards
Renê

 

[CLR]

You may have to do Tools > Add-ins > Analysis ToolPak first.............

Vaya con Dios,
Chuck, CABGx3