For something that's a little more eccentric:

=INDEX(FREQUENCY(A1:A20,{25,40}-{1,0}),2)

--
Biff
Microsoft Excel MVP


"T. Valko" wrote in message
...
Do you mean =25 and <=40 ?

Try this:

=COUNTIF(A1:A20,"=25")-COUNTIF(A1:A20,"40")


--
Biff
Microsoft Excel MVP


"benny" wrote in message
...
Is there a way to use the Count if function to count if a value is
between 25
and 40?

Using Excel 2003