Thanks, Dave....
I deserve a newspaper over the snout for missing such an obvious error in my
post. : |


***********
Regards,
Ron

XL2002, WinXP


"Dave Peterson" wrote:

Just a typo (or two):

=COUNTIF(A2:A200,"=101")-COUNTIF(A2:A200,"140")
or
=COUNTIF(A2:A200,"="&101)-COUNTIF(A2:A200,""&140)



kenm wrote:

Hi,

I'm trying to count a specific range of values that occurs between two
number in column. I tried some countif and IF functions but couldn't land the
right formula.
Any help is really appreciated.

Here's my example:

In a single column from A2:A200 there's a set of numbers with values ranging
between 1-200.
I'm trying to find a 'count' of all numbers in this column that fall
'between' 101-140.

thanks for your assistance,
_kenm

--
kenm

--

Dave Peterson