I realise this one's probably small fry for you all, but here goes anyway.
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?
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?