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),"<>FALSE")}
Any suggestions please
Thanks
Bookmarks