View original (French)

Nb if error

Solved
Alex -  
 Alex -
Hello,

Is there a formula in Excel to sum the cells displaying errors (#VALUE!) in a range of data?

Thank you in advance

3 answers

  1.
    JvDo Posted messages 1924 Registration date   Status Member Last intervention   859
     
    Hello,

    =SUMPRODUCT(--ISERROR(myRange))

    Best regards
    1
  2. Zoul67 Posted messages 2001 Status Member 149
     
    Hello,

    Try
    =COUNTIF(B1:B11;#VALUE!)

    Best regards
    1