hi,

formula array to validate with ctrl + shift + enter

=SUMPRODUCT(--IF(ISERROR(A2:A20),0,(A2:A20)),--NOT(ISERROR(A2:A20)))


--
isabelle



Le 2012-02-22 11:29, Cindy Wang a écrit :

-23285
-998
#N/A
-6474
-9406
-1715
#N/A
-12763
-1768
-628
#N/A
#N/A
-508
-2408
#N/A
#N/A
-81
-2628
-2
no, that will not work. I have used vlookup and some cell returned as
#N/A, and I try to sum those cells with value. I used your function
and it did not return anything at all.