counting cells

[raheem80]

Hi everyone,
I wish if anyone can help me.
I have made a table contains list of numbers and I want to count how many cells contains the numbers between 62 to 65 from the whole table.

Ex: the numbers are
85 58 95 62 62 78 65 36 63 64 76 64
as u see, we have 5 numbers in the range(62-65)

How can I do it in excel? what function should I use?
Please help me.
Thanx.

[Simon Lloyd]

Lets say that your range is A1:A10 and your values to search between are in B1 (lowest) and C1 (highest) then use this in D1:
=COUNTIF(A1:A10,"<="&C1)-COUNTIF(A1:A10,"<="&B1)

[raheem80]

Thank u very much Dear Mr. Simon.
But I think u didn't understand me.
What I want is the number of cells that contain values (any) of these numbers:62,63,64,65
in a specific range.

[Simon Lloyd]

=countif(a1:a20,62)+countif(a1:a20,63)+countif(a1:a20,64)+countif(a1:a20,65)

[olasa]

=SUMPRODUCT(--({62;63;64;65}=(A1:L13)))
; might need to be , or \ depending on what is used in your country.

or
=SUMPRODUCT(--(A2:A6=A1:L13))

or
=SUM(--(B1:B5=TRANSPOSE(A1:A13)) Array Entered (read the blue text).

All examples returns 6 for the enclosed example.

//Ola