Do you mean =20 but <= 30?

Try one of these:

=COUNTIF(A1:A10,"=20")-COUNTIF(A1:A10,"30")

=INDEX(FREQUENCY(A1:A10,{20,30}-{1,0}),2)

=SUMPRODUCT(--(A1:A10=20),--(A1:A10<=30))

--
Biff
Microsoft Excel MVP


"Excel worksheet funtions" <Excel worksheet
wrote in message
...
How can I calculate ages for example I have colums with ages and I need to
know how many people between of age of 20 to 30?