If I have a column of numbers from -100 to + 100 how can I count the
number of rows containing numbers between 40 and 50.

=COUNTIF(J$4:J$1058,AND("<50,40"))

Doesn't work. I get zero.

Thanks
Don

=SUMPRODUCT(--(J4:J105840),--(J4:J1058<50))


--
Regards,

Peo Sjoblom


"don" wrote in message
...
If I have a column of numbers from -100 to + 100 how can I count the
number of rows containing numbers between 40 and 50.

=COUNTIF(J$4:J$1058,AND("<50,40"))

Doesn't work. I get zero.

Thanks
Don

thanks Peo,
Can you expand this so the 40 portion is in a cell and can be
easily changed?
I tried a couple of versions and referring to a cell didn't seem to
work.

Thanks
Don


On Wed, 4 May 2005 20:36:21 -0700, "Peo Sjoblom"
wrote:

=SUMPRODUCT(--(J4:J105840),--(J4:J1058<50))

Try this, with value in J1, and < value in J2:

=SUMPRODUCT((J4:J1058J1)*(J4:J1058<J2))
--
HTH,

RD

---------------------------------------------------------------------------
Please keep all correspondence within the NewsGroup, so all may benefit !
---------------------------------------------------------------------------

"don" wrote in message
...
thanks Peo,
Can you expand this so the 40 portion is in a cell and can be
easily changed?
I tried a couple of versions and referring to a cell didn't seem to
work.

Thanks
Don


On Wed, 4 May 2005 20:36:21 -0700, "Peo Sjoblom"
wrote:

=SUMPRODUCT(--(J4:J105840),--(J4:J1058<50))

also you can try
=countif(J$4:J$1058,"<=50")-countif(J$4:J$1058,"<40")
play with the less than/less than or equals as needed.

"don" wrote:

If I have a column of numbers from -100 to + 100 how can I count the
number of rows containing numbers between 40 and 50.

=COUNTIF(J$4:J$1058,AND("<50,40"))

Doesn't work. I get zero.

Thanks
Don