You could try either:
=COUNTIF(A1:A6,"<#NUM!")
=SUM(IF(ISERR(A1:A6),0,1))

Art

"SD" wrote:

I would like to count the number of records which have good data , ignoring
the one's that have any errors

for eg: the data in cell A1:a6 is as follows:-

aa
bb
#NUM!
cc
#NUM!
dd

The count should give me 4 as only 4 out of the 6 above holds correct data

I cannot change the formula that is causing the error (like #NUM! above
using ISERROR route)

I am using this array formula but not able to get the desired result.

{=COUNTIF(IF(ISERROR(A1:A6)=FALSE,D57:D66),"<FALS E")}

Any suggestions please

Thanks