To test only one cell:
=AND(COUNTIF(A1,{"=25","<=40"}))
or
=COUNTIF(A1,"=25")*COUNTIF(A1,"<=40")


To test a range of cells:
=SUM(COUNTIF(A1:A25,{"<25","<=40"})*{-1,1})
or
=COUNTIF(A1:A25,"<=40")-COUNTIF(A1:A25,"<25")

Is that something you can work with?
--------------------------

Regards,

Ron (XL2003, Win XP)
Microsoft MVP (Excel)

"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