4 Replies Latest reply: Nov 27, 2017 9:56 PM by Devarasu R RSS

    SUM IF

    Fernando Hernandez Pico

      I have the following table

       

      RECLAMADAIMP_APNTE
      #N/A142536
      124578963300
      #N/A5000
      35489785235152456
      54879542335630065

       

      I need to add ONLY those values with RECLAMADA field different than #N/A

       

      I'm trying with this formula but the outcome is ZERO.. any ideas ?

       

      If(RECLAMADA = '#N/A', 1, Sum(IMP_APNTE))

       

      thanks