Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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? |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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? |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
count frequency of a word in range of cells | Excel Discussion (Misc queries) | |||
Frequency of numbers in a range | Excel Worksheet Functions | |||
Determining if a range of cells is missing a formula | Excel Worksheet Functions | |||
Why does a simple frequency distribution count out of range data? | Excel Worksheet Functions | |||
Frequency within date range | Excel Worksheet Functions |