Determining Frequency of range

[Leitodd]

I am creating a frequency chart so I have ranges from -14.5 to -15.50 through
+14.5 to 15.5. The data is in a separate spreadsheet. I am using
=(COUNTIF('Sheet'!L$5:L$63,{">-14.5","<-15.5"})). It is pulling the count for
the entire range but not the range for greater than -14.5 and less than -15.5
only.

What do I need to do differently?

 

[Jacob Skaria]

Try SUMPRODUCT. Another point to be noted is that -14.5 is greater than -15.5

=SUMPRODUCT((Sheet!L5:L63<-14.5)*(Sheet!L5:L63>-15.5))

If this post helps click Yes

 

[T. Valko]

greater than -14.5 and less than -15.5

Are you sure that's the range you want to count? If you have a value
of -14.51 it would not be counted. When dealing with negative numbers "less
than" and "greater than" logic gets reversed.

For example, you mght mean to count like this:

greater than -15.5 and less than -14.5

In this case -14.51 would be counted.