Try this:

=COUNTIF(B:B,"=18")-COUNTIF(B:B,"59")

Better to use cells to hold the boundary values:

D1 = 18
E1 = 59

=COUNTIF(B:B,"="&D1)-COUNTIF(B:B,""&E1)

--
Biff
Microsoft Excel MVP


"Jen" wrote in message
...
I am trying to have excel count numbers that fall between certain numbers.
I.e. all numbers in column B that range from 18-59 (that include the #18
and
# 59). I have tried the COUNTIF fx but can only do "=18" and "<=59" This
ends up counting all numbers above 18 and all numbers below 59. I tried
BETWEEN 18 AND 59 but I obvoiusly don't know the appropiate language.
Thanks
in advance. Jen