correction:

array formula to validate with ctrl + shift + enter

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


--
isabelle



Le 2012-02-22 13:34, isabelle a écrit :
hi,

formula array to validate with ctrl + shift + enter

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


--
isabelle