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