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