I'm trying to count the number of times certain values occur in range. The values I want to find are:

between 0 and 1 (i.e. less than 1)

between 1 to 2 (i.e. including values of 1.0 but less than 2.0)

between 2 to 3 etc etc

This is the formula I am using for 'between 1 and 2' is:

=COUNTIF($U$2:$U$1323,">=1")-COUNTIF($U$2:$U$1323,">2")

The formula for '0 to 1' is easy and works, but the above formula for the rest is giving me too high a number. What am I doing wrong?