| 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? |
| 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 | |||
Threaded Mode
