Hi,

Another way:

=SUMPRODUCT((A2:A200=101)*(A2:A200<=140))

Cheers!
Jean-Guy

"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