Determining Frequency of range
 

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?

Determining Frequency of range
 

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
---------------
Jacob Skaria


"Leitodd" wrote:

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?

Determining Frequency of range
 

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.

--
Biff
Microsoft Excel MVP


"Leitodd" wrote in message
...
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?