7 Replies Latest reply on Apr 24, 2018 5:34 PM by Keith Braithwaite

    Sumifs

    Keith Braithwaite

      I would like to create a calculated field where I count records based on multiple criteria. In excel the formula is =countifs(AccountID,[@AccountID],CreatedDate,>[@CreatedDate]). Is this possible? I included a sample table below. Any help would be appreciated

       

      AccountIDCreated DateUserContacts per Account (Desired Result)Contacts per Account (Calculated Field)
      joe@mail.com1/1/2018

      Agent

      3
      sue@mail.com1/1/2018Agent 21
      joe@mail.com1/5/2018Agent 22
      sue@mail.com1/6/2018Agent0
      joe@mail.com1/8/2018Agent1
      pete@mail.com1/7/2018Agent 20
      joe@mail.com1/12/2018Agent 20