Determining Frequency of range

L

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?
 
J

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

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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top