Counting a specific range of values within a column
 

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

Counting a specific range of values within a column
 

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

Counting a specific range of values within a column
 

Try this:

=COUNTIF(A2:A200,=101)-COUNTIF(A2:A200,140)

Does that help?
***********
Regards,
Ron

XL2002, WinXP


"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

Counting a specific range of values within a column
 

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

Counting a specific range of values within a column
 

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

Counting a specific range of values within a column
 

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

Counting a specific range of values within a column
 

Ron,
This worked perfectly!

Thanks for the assistance.
--
kenm


"Ron Coderre" wrote:

Try this:

=COUNTIF(A2:A200,=101)-COUNTIF(A2:A200,140)

Does that help?
***********
Regards,
Ron

XL2002, WinXP


"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

Counting a specific range of values within a column
 

Sean,

Both you and Ron had this one nailed.

Really appreciated the very quick response and your excellent help.

_kenm
--
kenm


"Sean Timmons" wrote:

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