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
|