| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
counta if iserror
I want to count the errors in my text column.
To start I have the following, but I think I need to use the counta function instead. =COUNTIF(F5:F18,ISERROR(F5:F18)) I think I neeed to do a if(counta,,) as an array formula but not sure how to do it. Any help appreciated. Bruce |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
counta if iserror
=SUMPRODUCT(--ISERROR(F5:F18))
"Bruce" wrote: I want to count the errors in my text column. To start I have the following, but I think I need to use the counta function instead. =COUNTIF(F5:F18,ISERROR(F5:F18)) I think I neeed to do a if(counta,,) as an array formula but not sure how to do it. Any help appreciated. Bruce |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Iserror & VBA | Excel Discussion (Misc queries) | |||
| ISERROR - #NAME? | Excel Worksheet Functions | |||
| ISERROR | Excel Worksheet Functions | |||
| iserror | Excel Discussion (Misc queries) | |||
| COUNTA Function not working =COUNTA(C3:C69,"NH") | Excel Worksheet Functions | |||
Hybrid Mode
