Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Why does a simple frequency distribution count out of range data?
I have a frequency distribution that counts the occurance of 1, 2, 3 or 4 in
column C but for some reason if there is a 0 in a cell it gets counted as a 1. Here is an excerpt from the spreadsheet. Row Col P Col Q Formula in Q3-Q6 =FREQUENCY(C10:C2000,$P$3:$P$6) 3 1 77 4 2 113 5 3 48 6 4 0 All of the data in columns A-L is imported each month and C10:C2000 contain either text (as part of merged cells) or 1-4 formatted as "General" or are blank. I have tried reformatting C10:C2000 as numbers but it makes not differance. Does anyone know what is happening and how to correct for it? |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Why does a simple frequency distribution count out of range data?
|
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Why does a simple frequency distribution count out of range data?
Biff wrote...
Or use Sumproduct which is easier to understand for most people. COUNTIF would be easier and more understandable still. FREQUENCY was meant to deal with fractional valued data points, not a handful of integers. For what it's meant for, its behavior is necessary. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Inputting data to one worksheet for it effect another | Excel Discussion (Misc queries) | |||
How can you sum the last 5 columns of data from a range of data | New Users to Excel | |||
Excel Macro to Copy & Paste | Excel Worksheet Functions | |||
Sort pages? | Excel Discussion (Misc queries) | |||
Pulling data from 1 sheet to another | Excel Worksheet Functions |