counta if iserror

[Guest]

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

 

[Guest]

=SUMPRODUCT(--ISERROR(F5:F18))