Oops..correction..

=0<SUMPRODUCT(--(ISERROR(A2:A300)))

If this post helps click Yes
---------------
Jacob Skaria


"Jacob Skaria" wrote:

Try the below

=1=SUMPRODUCT(--(ISERROR(A2:A300)))

If this post helps click Yes
---------------
Jacob Skaria


"diepvic" wrote:

Hi,
can I use Iserror for an array?
like ISERROR(A2:A300)
I've tried this with a non-error array. The result is TRUE, which means
there's an error in the array. I'm quite confused.

Pls help.