Count #BUSY! errors

[mookyon]

Hi,
I wish to count and display a gage for progress of resolving an area with many potential #BUSY! errors.

Neither the SUMPRODUCT method (w\ --IFERROR), nor the AGREGATE function (with the ignore option equals 6) worked.

Can anyone think of a way to count the number of such errors?

THX

 

[arthurbr]

Something like

=SUMPRODUCT(--ISERROR(a1:a10))

 

[mookyon]

Something like

=SUMPRODUCT(--ISERROR(a1:a10))

THX. Unfortunately ISERROR and IFERROR does not identify #BUSY! as countable errors...

 

[arthurbr]

If you have that error in a cell, A1, say, what does =TYPE(A1) return ?
IFERROR is something else altogether

 

[mookyon]

Welcome again arthurbr.
TYPE replicate the error. I.e., =TYPE(STOCKHISTORY("IBM",DATE(2020,1,3),,0,0)) will generate #BUSY! error while processing, and will retrun 1 upon comletion of retrieval (following re-calculation). Retrival of a large region might take hours...

Note as well, the error display is alternating a number of times per minute between #BUSY! and #CALC!, but this #CALC! is not similar to the permanent #CALC! error (where TYPE returns 16).

Note as well the ERROR.TYPE Function fails as well whenever a cell with #BUSY! error is passed as an argument.

THX!