Simplest is to do:

=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