| Home |
| Search |
| Today's Posts |
|
#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. |
| 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 | |||
Threaded Mode
