V

#### vsoler

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?