Range A1:A50 contains texts, numbers, blank cells & error cells (#N/A
and #DIV/0! basically).

I want to have in B1:B50 the count of the cells that are less than the
corresponding cell in A1:A50 using SUMPRODUCT and disregarding the
error values.

I have tried with (in B1):

=IF(NOT(ISERROR($A$1:$A$50)),SUMPRODUCT(--(NOT(ISERROR($A$1:$A
$50)))*($A$1:$A$50<A1)))

and copying down to B50.

However, I keep on getting #N/A as the result of my formula. The last
portion of the formula ($A$1:$A$50<A1) return #N/A that is not
overcome by the preceding ISERROR conditions.

Can anybody help?