| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
frequency excl #N/A
Thanks very much - that gave me what I needed
"Shane Devenshire" wrote: Hi, You didn't tell us the formula you are using for frequency, so If you are using COUNTIF then =COUNTIF(A$1:A$9,C1) No array needed and no check for the NA. If you are using FREQUENCY thent ry the following array entered formula: =FREQUENCY(IF(ISNA(A1:A9),"",A1:A9),C1:C4) Where A1:A9 is your data, C1:C4 is your bin range. -- If this helps, please click the Yes button Cheers, Shane Devenshire "Saintsman" wrote: How do I calculate the frequency for a set of numbers which includes #NA error ie ignore the error Thanks |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Use excl (2002) in presentation | Excel Discussion (Misc queries) | |||
| How can I always ROUND UP to the nearest multipal of 5 in excl | Excel Worksheet Functions | |||
| will Excl run on windows xp home edition? | Excel Discussion (Misc queries) | |||
| Subtotal excl errors | Excel Worksheet Functions | |||
Hybrid Mode
