4 Replies Latest reply on Feb 18, 2017 1:32 PM by Alec Guerenstein

    If amount = Empty ?

    Béatrice LORIOT

      Good afternoon,

       

      Can't figure out the formula to count empty values. My data countain IDs and amount numbers. I need to count all ID which amount is EMPTY, or equal or above 100 as per below. Result would be 3 IDs, for a total amount of 201.

      Thanks a lot

      KR

       

      idamount
      12340
      12350
      1236
      12371
      12381
      1239100
      1230101
      Count all ID which amounts are empty,  or equal to or above 100
      IDAmount
      1236
      1239100
      1230101